Hi,

I'm trying to rank some values where more than one cell may contain the same value. Normally Ranking these would give these values the same rank which is fine, but the next value would not follow, but skip a few numbers:

Example:

Data Rank
30 2
10 6
20 4
20 4
30 2
50 1

What I would like it to do is:

Data Rank
30 2
10 4
20 3
20 3
30 2
50 1

Any suggestions would be very much appreciated.

Kind regards
Paul