Greetings Gents,
I'm looking for a way to rank a named range from 1 to 16 with VBA. 16 being top position and 1 being bottom. Now for the tricky part, I need a way to allot for ties "duplicates" in a manner such as this:
Points Name Score
16 Bill 100
14.5 Tom 90
14.5 Mark 90
13 Ryan 80
Notice how 15 and 14 is replaced with (2) 14.5s
Please see my attached workbook example. And thank you for any help with this matter. [ATTACH]n1218161[/ATTACH]