數字重複最多次數 (11449)

K2 {=TEXT(MAX(COUNTIF(A2:I2,A2:I2)),"[>1]0;")

另解=TEXT(COUNTIF(A2:I2,MODE(A2:I2)),"0;;")



留言