I want to find a formula or conditional formatting that would automatically highlight the highest 20% of the scores in a row, but only the first 20%, no duplicates.
So in this case there are 13 values in each row, so 20% is 2.6 or rounding up, 3. So I want to highlight the 3 highest values, which should be the 8,8, and 9 in row 1
highlight1.xlsx