如何在excel中筛选出两列中相同的数据并配对排序答:假定原数据在SHEET1工作表中,请在SHEET2工作表A1单元格输入公式:=IF(ROW()>SUM(IF(COUNTIF(Sheet1!C:C,Sheet1!$A$1:$A$3),1)),IF(ROW()>COUNTA(Sheet1!A:A),"",INDEX(Sheet1!A:A,SMALL(IF(COUNTIF(Sheet1!C:C,Sheet1!$A$1:$A$3),65536,ROW($1:$3)),ROW()-SUM(IF...