Hi I have to colour cells green which are the top 6 scores. When a person has 2 scores the same it highlights 7 cells and when they have 3 scores the same it highlights 8 cells. I would like it to highlight 6 cells even if the scores for example were 100, 99, 99, 95,99, 95,94,100,92,91, I only want the two 100's, the three 99's and the 95 highlighted.
Thank you in advance I am very new to this and self taught I learn by googling and doing. Rebecca
Bookmarks