请教excel怎么批量快速提取关键字所在行数据出来?答:比如原数据在sheet1,你在sheet2的A2输入=IF(ISERROR(INDEX(Sheet1!A$1:A$2001,SMALL(IF(Sheet1!$B$1:BE$2001="关键字",ROW(Sheet1!$B$1:$B$2001),4^8),ROW(B1))),"",INDEX(Sheet1!A$1:A$2001,SMALL(IF(Sheet1!$B$1:$B$2001="关键字",ROW(Sheet1!$B$1:$B$2001),4^...