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