=INDEX(B:B,SMALL(IF(MATCH(B$2:B$10,B$2:B$10,)=ROW($2:$10)-1,
row()-1 =IF(ROW()>SUM(IF($B$2:$B$10=$E$2,1,0))+1,"",INDEX($C
INDEX(B:B,SMALL(IF($A$2:$A$25=$E$1,ROW($A$2:$A$25),65536),RO
=INDEX($A$1:$A$30,MATCH(SMALL($B$1:$B$30,ROW()),$B$1:$B$30,0
=IF(ROW(A1)>SUM($B$1:$B$19),"",INDEX(A:A,SMALL(IF($B$1:$B$19
=INDEX(AA!H:H,SMALL(IF(AA!$B$2:$B$2001=$C$3,ROW($2:$2000),4^
=INDEX(A:A,SMALL(IF(ISNUMBER(FIND(B$1,A$1:A$100)),ROW($1:$10
关于=INDEX(D:D,SMALL(IF($B$3:$B$11=$B$15,ROW($B$3:$B$11),65536
=INDEX(A:A,SMALL(IF(ISERROR(FIND("城区",$B$1:$B$6)),4^8,ROW($B
求解数组公式 =INDEX(总成绩!B:B,SMALL(IF(总成绩!$C$2:$C$505=$K$1,ROW($2:$
请教筛选公式数组含义 =INDEX(A:B,SMALL(IF(MATCH(A$2:A$19&B$2:B$19,A$2:A
=IF(MOD(ROW()+1,3)=0,INDEX(B:B,ROW()+4)/3,
=INDEX($B:$B,SMALL(IF($A$1:$A$17=$D2,ROW($1:$17),4^8),COLUMN