Rank : how to prevent duplicates.


How do I fix so I do not have duplicates.

thank you for any help anyone provides

What duplicates? We don’t know your data, we don’t know your results. RANK() just determines the rank of a value within a given set of data.

If you have duplicates / repetitions, you have duplicates. No fix insofar.
The exactly same value occurring more than once in a sequence of numbers has the same rank on every occurrence. the higher ranks are omitted as often as a repetition occurs and the next number to be ranked in the chosen order gets the first rank number unused so far. That’s the way ranking is done everywhere.
If you need disambiguation, you need to specify in what way. It cannot be done for sets.

Disambiguation of ranks always requires to introduce a “second key of order”.
If the numbers to rank are taken from a cell range which is part of a single column e.g. you can use the row number for disambiguation in many cases. You will have to assure something about the numeric range and the range of row numbers as well to allow for a reliable solution.


Perhaps it’s what you are looking for.