每行最大值 各欄出現次數 (15334)

H4:H22=IF(B4="","",MATCH(MAX(C4:G4),C4:G4,))

C24:G24=COUNTIF($H:$H,COLUMN(A1))

C3:G3=COUNT(C4:C22)

無輔助C2:G2{=SUM(N(RIGHT(SMALL($C4:$G22/1%+ROW(1:19)*10^6+{1,2,3,4,5},ROW(1:19)*5),2)*(MMULT(N($C4:$G22>0),{1;1;1;1;1})>0)=COLUMN(A1)))

C4:G22格式化=(MAX($C4:$G4)=C4)*(C4<>"")