Hi,
i would like to highlight the 5 biggest values in a range.
But not using the "top 5" standard formatting option from excel.
I would like to see MAXIMAL 5 values which are highlighted.
Example:
Data range: 5 5 5 5 3 3 2 4 3 4 3
Desired result: 5 5 5 5 3 3 2 4 3 4 3
or other example:
5 5 5 5 5 5 5 5 5 5 4
So the '4' is only highlighted 1 time in the first example, the 5 only 5 times in the second example.
Excel attached
Bookmarks