clark8529
03-20-2017, 03:13 AM
Hi,
I have a list of participants for a contest. As such, I need to rank the participants according to their respective scores from highest (1) to lowest (500).
The easiest way is definitely sorting the names by score from highest to lowest but I am not allowed to do that. My superior wants the list to maintain its originality while the names gets ranked. Can anyone suggest some help that uses VBA to code? A sample of the list looks like this:
Names
Score
Rank
Jason M.
34
Mark W.
12
Clark P.
50
Alex C.
98
Alexis Q.
93
Nathaniel A.
23
Lewis L.
45
James J.
78
Joseph G.
54
Jessie G.
32
Joe D.
34
John H.
53
Pepper M.
99
Nathalie M.
93
And the list goes on... Appreciate if anyone could help me with it.
I wanted VBA because this will not be only time I have to do this. So if there is a code to it, I can just use the code again the next time this task comes by.
I have a list of participants for a contest. As such, I need to rank the participants according to their respective scores from highest (1) to lowest (500).
The easiest way is definitely sorting the names by score from highest to lowest but I am not allowed to do that. My superior wants the list to maintain its originality while the names gets ranked. Can anyone suggest some help that uses VBA to code? A sample of the list looks like this:
Names
Score
Rank
Jason M.
34
Mark W.
12
Clark P.
50
Alex C.
98
Alexis Q.
93
Nathaniel A.
23
Lewis L.
45
James J.
78
Joseph G.
54
Jessie G.
32
Joe D.
34
John H.
53
Pepper M.
99
Nathalie M.
93
And the list goes on... Appreciate if anyone could help me with it.
I wanted VBA because this will not be only time I have to do this. So if there is a code to it, I can just use the code again the next time this task comes by.