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..
Bookmarks