Excel如何自动把满足条件的整行复制到另一张表上并按某列数据的大小排序...答:满足什么条件?学历为大专?在表2的A2输入=IF(ISERROR(INDEX(表1!A$1:A$3000,SMALL(IF(表1!$C$1:$C$3000="大专",ROW($C$1:$C$3000),4^8),ROW(A1))),"",INDEX(表1!A$1:A$3000,SMALL(IF(表1!$C$1:$C$3000="大专",ROW($C$1:$C$3000),4^8),ROW(A1)))按CTRL+shif...