excel =IF(ROW(B1)>COUNTIF(B:B,L$1),"",L$1)=INDEX(C:C,SMALL(I

excel =IF(ROW(B1)>COUNTIF(B:B,L$1),"",L$1)=INDEX(C:C,SMALL(I row()-1 =IF(ROW()>SUM(IF($B$2:$B$10=$E$2,1,0))+1,"",INDEX($C 求解数组公式 =INDEX(总成绩!B:B,SMALL(IF(总成绩!$C$2:$C$505=$K$1,ROW($2:$ =INDEX(AA!H:H,SMALL(IF(AA!$B$2:$B$2001=$C$3,ROW($2:$2000),4^ =IF(ROW(A1)>SUM($B$1:$B$19),"",INDEX(A:A,SMALL(IF($B$1:$B$19 EXCEL公式解读:B2=INDEX(A:A,MIN(IF(COUNTIF(B$1:B1,A$1:A$1000)=0,R 谁知道这个公式是什么意思{=MIN(IF(COUNTIF(C$1:C1,B$1:B$49)=0,ROW(INDIRECT =INDEX(A:A,SMALL(IF(ISERROR(FIND("城区",$B$1:$B$6)),4^8,ROW($B excel中=COUNTIF($B:$B,B1)>1 =INDEX($B:$B,SMALL(IF($A$1:$A$17=$D2,ROW($1:$17),4^8),COLUMN INDEX(B:B,SMALL(IF($A$2:$A$25=$E$1,ROW($A$2:$A$25),65536),RO =INDEX($B$1:$I$1,SMALL(IF($B$2:$I$2=$C$8,COLUMN($B$2:$I$2),8