请问数组公式:index($b:$b,small(if(($a:$a=$d2),row(a:a),4^8),column
请问数组公式:index($b:$b,small(if(($a:$a=$d2),row(a:a),4^8),column
=INDEX($B:$B,SMALL(IF($A$1:$A$17=$D2,ROW($1:$17),4^8),COLUMN
=INDEX(A:A,SMALL(IF(ISERROR(FIND("城区",$B$1:$B$6)),4^8,ROW($B
=IF(ROW(A1)>SUM($B$1:$B$19),"",INDEX(A:A,SMALL(IF($B$1:$B$19
INDEX(B:B,SMALL(IF($A$2:$A$25=$E$1,ROW($A$2:$A$25),65536),RO
请教筛选公式数组含义 =INDEX(A:B,SMALL(IF(MATCH(A$2:A$19&B$2:B$19,A$2:A
请教:函数含义 有一个公式:=INDEX(A:A,SMALL(IF(COLUMN(1:1)
=INDEX(A:A,SMALL(IF(ISNUMBER(FIND(B$1,A$1:A$100)),ROW($1:$10
=INDEX(Sheet1!A:A,SMALL(IF(MATCH(rr,rr,)=ROW(rr),ROW(rr),4^8
=INDEX($A$1:$H$1,SMALL(IF($A$2:$H$2=$B$8,COLUMN($A$2:$H$2),8
=INDEX(A:A,SMALL(IF($A$1:$A$12=1000,ROW($A$1:$A$12),20),ROW(
=INDEX($A$1:$A$30,MATCH(SMALL($B$1:$B$30,ROW()),$B$1:$B$30,0