Rank based on 3 different columns

[pierrek]

So I want to rank a group based on the following order:

1. Points
2. Goal Difference
3. Score For

So if "points" are equal between two teams, I want to check their "goal difference". And if the "goal difference" is also equal then check for the "score for".

If all three of those are equal then its fine to have two teams with the same rank

I need help finding a formula to do that.



I have attached a sample excel to test on.

[menem]

If you don't mind to use helper cells.

N6 (copy down to N8)
=E6*10000+L6*100+J6

C6
=RANK(N6,$N$6:$N$8)

Regards.

Note : Please change your ms-office version in your profile.

[wk9128]

Try Cell C6 formula , Drag down

Please Login or Register  to view this content.