Hi,

I have a list of 3000+ rows of percentages ranging from negative to positive values containing many duplicate values.

I need them to rank from 1 - 3000+ if possible.

I've tried the RANK function and also some SUMPRODUCT suggestions in here but to no avail.

Thanks!