=INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$A$1:$A$100=1,ROW($1:$100)
=INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$A$1:$A$100=1,ROW($1:$100)
=OFFSET(Sheet1!$A$1,SMALL(IF(Sheet1!$A$2:$A$11=$A$1,ROW($A$1
=INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$D$2:$D$500="合约",ROW($A$2:
IF(MOD(ROW(),3)=0,"",IF(MOD(ROW(),3)=1,Sheet1!A$1,INDEX(Shee
=INDEX(Sheet1!A:A,SMALL(IF(MATCH(rr,rr,)=ROW(rr),ROW(rr),4^8
=INDEX(sheet1!H:H,small(if(sheet1!Y$1:Y$100
=OFFSET(Sheet1!A$1,MAX(0,ROW()*10-11),) =OFFSET(Sheet1!A$1,R
{=indirect("Sheet1!A"&row(1:16))},公式正解.
=INDEX(A:A,SMALL(IF(ISNUMBER(FIND(B$1,A$1:A$100)),ROW($1:$10
=INDEX(A:A,SMALL(IF($A$1:$A$12=1000,ROW($A$1:$A$12),20),ROW(
=INDEX(Sheet1!A:A,ROW(A1)/10+1)请问这个函数 我们表格是中文名字怎么不行?求教这个函数每个
去重的函数用=index(A:A,SMALL(IF(MATCH(A1:A100,A1:A100)=ROW(1:100),