A1:A8{=COUNT(MATCH(TRIM(MID(SUBSTITUTE(B1," ",REPT(" ",99)),ROW($1:$9)*99-98,99))*1,D:D,))
H2:H6{=INDEX(B:B,SMALL(IF((A$1:A$8>=F$2)*(A$1:A$8<=F$6),ROW($1:$8),99),ROW(A1)))&""
I2:I6{=INDEX(B:B,SMALL(IF((MMULT(1-ISNA(MATCH((0&TRIM(MID(SUBSTITUTE(B$1:B$8," ",REPT(" ",99)),COLUMN(A:I)*99-98,99)))*1,D:D,)),ROW(1:9)^0)>=F$2)*(MMULT(1-ISNA(MATCH((0&TRIM(MID(SUBSTITUTE(B$1:B$8," ",REPT(" ",99)),COLUMN(A:I)*99-98,99)))*1,D:D,)),ROW(1:9)^0)<=F$6),ROW($1:$8),99),ROW(A1)))&""
另解 I2:I6{=INDEX(B:B,SMALL(IF(TEXT(MMULT(1-ISNA(MATCH((0&TRIM(MID(SUBSTITUTE(B$1:B$8," ",REPT(" ",99)),COLUMN(A:I)*99-98,99)))*1,D:D,)),ROW(1:9)^0),"[>"&F$6&"]99;[<"&F$2&"]99;0")*1<99,ROW($1:$8),99),ROW(A1)))&""
留言
張貼留言