I've been trying to come up with an efficient way to rank a set of data that's in a table...
For example...
If I have the following data (note: this data is dynamic and will change depending on other inputs)
Now, I want to create a duplicate table below this one, but instead of the values, I want it to show ranking of the data. Rankings must be unique.
Has anyone come up with a simple way how to do this?
I've tried this per another forum suggestion:
=RANK(A1,$A$1:$I$9,0)+COUNTIF($A$1:A1,A1)-1
This is close but doesn't work - In my example above, D6 and E5 will receive the same ranking, because D6 will be looking above and to the left (does not see E5) and E5 will be looking above and to the left (does not see D6). They have the same ranking.
If anyone can help, I'd really appreciate it.
Thanks in advance
Bookmarks