Ranking from 3 or more columns

[manster]

Hi everybody, from reading other threads, I understand how to rank 2 columns.

A B C
1 12 99 3
2 13 98 1
3 13 55 2
4 11 55 4
5 11 54 5

by using the following ranking formula in C1

=RANK(A1,$A$1:$A$5)+SUMPRODUCT(--($A$1:$A$5=A1),--($B$1:$B$5>B1))

My question is, how would you go about ranking from three columns? To give you the following result...

A B C D
1 12 99 23 3
2 13 98 56 1
3 13 55 22 2
4 11 55 23 4
5 11 54 65 5

Thanks,
manster

[DonkeyOte]

A simple solution would be to sum the values but in such a way as to generate an accurate result where no band overlaps another and each is weighted according to it's importance in determining rank (ie order by A, then B & then C (not by sum of A:C))

eg first create your unique identifier:

D1: =A1+(B1/1000)+(C1/1000000)
copied down

Your rank is thus based off D1

E1: =RANK($D1,$D$1:$D$5)
copied down

[manster]

That's so straight forward and simple. Thank you!