excel如何对三列不同数据进行归类统计就是将物理化学生物,化学生物物理...答:F2公式:=IFERROR(INDEX(B:B,SMALL(IF(MATCH(SUBSTITUTE(MMULT(IF(COUNTIF(OFFSET($B$1:$D$1,ROW($1:$40),),{"物理","化学","生物","地理","历史","政治"}),COLUMN($A:$F),),10^(6-ROW($1:$6))),0,""),SUBSTITUTE(MMULT(IF(COUNTIF(OFFSET($B$1:$D$1,ROW($1:$40...