最高低前三名固定得分 (10231)

C3 下拉 再複製各列=TEXT(SUMPRODUCT(N(CHOOSE({1,2,3},$B$3:$B$13,$F$3:$F$13,$J$3:$J$13)>B3)),"[>"&SUMPRODUCT(N(CHOOSE({1,2,3},$B$3:$B$13,$F$3:$F$13,$J$3:$J$13)>0))-4&"]6!0;[<3]1!0!0;"&RANDBETWEEN(61,99))