Compare values and count number of max values

[blueflwr19]

Trying to put together a score sheet for a game. I have data listed as follows:

Level Player 1 Player 2 Player 3 Player 4
1 50000 65000 80000 90000
2 60000 59000 58000 70000
3 55000 40000 45000 46000

# high pts 1 0 0 2

I've been searching the forum and the web for an easy way to compare the number of maximum scores that each player has. For example, for numbers of times Player 1 has the maximum score is 1, whereas Player 4 has 2.

I've learned that I can't count my CF colors for the high scores, but surely there's a way to use the formula to get the conditional formatting to count??? Just not sure where to start so that I can compare each row and get a total count at the end.

[Marcol]

A simple way might be to use Rank in a similar sized grid to you scores

Then Countif Rank =1 for each player