Hi there, in column A i have numbers. Some of which are repeated.
I want to be able to rank teh numbers without the repeated ones counting twice.
For instance if my data in col a was
4
15
7
21
6
16
15
7
8
3
4
and I want to rank largest to smallest it currently shows
21
16
15
15
8 etc etc
How can i correct the formula so 15 only shows once?
Bookmarks