Forum Discussion
Please Help Excel Rank Dilemma
Name Score back 6 back 3 back 1 Rank Rank should be John 26 13 5 1 6 6 Howard 26 11 6 0 5 7 Kevin 26 14 5 3 2 5 Declan 26 14 8 4 2 2 ...
As I said, my approach was "one way." One of the delightful things about Excel is that there are always several different ways to get from point A (the problem) to B (the solution). Patrick2788 has given one that comes at the problem a different way, leaving the original array as it was in your introductory request, and producing the final column with the correct ranking.
I chose to rearrange the original array in sorted order.
Which result is "better" depends, as is often the case, on what you will be doing with that result, that output.