每行有 0 ~ 4最大數 (14069)

H2{=RIGHT(MAX(IFERROR(FIND(B2:F2,"01234"),0.6)))-1

另解=IFERROR(MATCH(9,0/COUNTIF(B2:F2,{0;1;2;3;4}))-1,5)

另解=IFERROR(LARGE(B2:F2,COUNTIF(B2:F2,">4")+1),5)



留言