I have an excel sheet which has scores for multiple players in a league competition.
The results are are based on each players top 8 scores only and i have a formula which calculates this.
Is there any way of conditional formatting this sheet so that the best 8 scores only are also highlighted for each player.
I have used the normal top 8 function, but it highlights any duplicate scores of the same value at the bottom of the range so therefore the 9-10 best scores will also be highlighted instead of just the 8 the formula is calculating.
For example, if 7 is the 8th best score of a players results, but they also have two other scores of 7, it currently will highlight all three of the scores of 7.
I only want it to highlight the one 7 which is included in the total score.
Is there any way of doing this?