Greetings,
I have a situation where I need to Rank a series of numbers. I would like the macro to traverse through the list, apply the rank. There will be duplicates, and these would all receive the same rank.
example:
Points
93
84
78
75
66
62
61
60
59
59
57
57
55
55
53
53
52
52
50
50
50
Result would be:
Points
93 1
84 2
78 3
75 4
66 5
62 6
61 7
60 8
59 9
59 9
57 10
57 10
55 11
55 11
53 12
53 12
52 13
52 13
50 14
50 14
50 14
Etc… until end of list.
Thanks Brad
