判斷 连续3个有數字 (10024)

H2{=IF(OR(FREQUENCY(IF(B2:F2>0,COLUMN(B:F)),IF(B2:F2=0,COLUMN(B:F)))>2),"全码","残码")

另解{=IF(OR(SUBTOTAL(2,OFFSET(A2,,ROW($1:$5),,3))=3),"全码","残码")