Ranking Multiple Columns(3)

[Bullfn33]

I would like to rank users based on three columns in order. The users should be ranked by highest number of wins(W), then by highest number of points(PTS), then by possible points remaining(PPR). The ranks should display in column A(RK).

The closest I get was using this formula which did not quite work.

=RANK(D2,$D$2:$D$25)+SUMPRODUCT(--($D$2:$D$25=D2),--($E$2:$E$25=E2),--($F$2:$F$25>F2))

See attached sample sheet. btw, I'm using Excel 2010. thank you

[Marcol]

Try using a helper column, say Column H (this can be hidden)
In H2

Please Login or Register  to view this content.

Drag/Fill Down

Then in A2

Please Login or Register  to view this content.

Drag/Fill Down

Then sort by the helper column Largest to Smallest

Hope this helps.

[Bullfn33]

Hi Marcol,

That worked great! Thank you so much.