眾數 三條件顯示 (15212)

D2{=REPT(C2,ROW()=100-RIGHT(MAX(IF(B$2:B$21=B2,COUNTIFS(B$2:B$21,B$2:B$21,C$2:C$21,C$2:C$21)/1%%+C$2:C$21/1%+(100-ROW($2:$21)))),2))



留言