含1-3个数的单元格选出来 (9859)

無輔助 D2{=INDEX(B:B,SMALL(TEXT(TEXT(MMULT(((0&TRIM(MID(SUBSTITUTE(B$1:B$8," ",REPT(" ",99)),COLUMN(A:I)*99-98,99)))-10>=0)*((0&TRIM(MID(SUBSTITUTE(B$1:B$8," ",REPT(" ",99)),COLUMN(A:I)*99-98,99)))-19<=0),ROW(1:9)^0),"0;;99"),"[>3]99;"&ROW($1:$8))*1,ROW(A1)))&""

符合條件 (輔助) A1=REPT("V",OR(INDEX(FREQUENCY((0&TRIM(MID(SUBSTITUTE(B1," ",REPT(" ",99)),ROW($1:$9)*99-98,99)))*1,{9,19}),2)={1,2,3}))

有輔助{=INDEX(B:B,SMALL(IF(A$1:A$8="V",ROW($1:$8),99),ROW(A1)))&""

無輔助 {=INDEX(B:B,SMALL(IF(ABS(MMULT(IFERROR(FIND(COLUMN(J:S)&" ",B1:B8&" ")^0,),ROW(1:10)^0)-2)<2,ROW($1:$8),99),ROW(A1)))&""