Ranking based on multiple columns criteria

[allisonb]

Hi All

i need help with a ranking formula..

in the attached workbook, the ranking is done by points (column H) then Time (Column G) ... however the minimum criteria for points is 50, so those players who achieve 60 don't place higher than those who only achieved 50 with a faster time.

I have included the desired ranking result in column K..

Many thanks in advance..

[Phuocam]

Try this:

=SUM(--(IF($H$4:$H$8>50,50,$H$4:$H$8)*1000000-$G$4:$G$8>IF(H4>50,50,H4)*1000000-G4))+1

**Array formula, enter with Ctrl+shift+Enter

[allisonb]

That worked.. Thankyou very much i was no where near getting it to work..