數字最大 999 E2:N5{=IFERROR(SMALL(IF(ISNUMBER(FIND(" "&ROW($1:$999)&" "," "&$B$2&" "))*(ROW($1:$999)>=400),ROW($1:$999)),ROW(A1)*10-10+COLUMN(A1)),"")
E6:N6 下拉{=IFERROR(SMALL(IF(ISNUMBER(FIND(" "&ROW($1:$99)&" "," "&$B$2&" "))*(ROW($1:$99)<=40),ROW($1:$99)),ROW(A1)*10-10+COLUMN(A1)),"")
數字無限 E2:N5{=IFERROR(SMALL(IF((0&TRIM(MID(SUBSTITUTE($B$2," ",REPT(" ",299)),ROW($1:$99)*299-298,299)))*1>=400,(0&TRIM(MID(SUBSTITUTE($B$2," ",REPT(" ",299)),ROW($1:$99)*299-298,299)))*1),ROW(A1)*10-10+COLUMN(A1)),"")
留言
張貼留言