Compare values and count number of max values
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.
A simple way might be to use Rank in a similar sized grid to you scores
Then Countif Rank =1 for each player
If you need any more information, please feel free to ask.
However, if this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the small Star icon botom left of thier post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks