Hi all
Haven't posted for a while, but am working on a golf competition spreadsheet that ranks the order of the candidates, eliminating ties.
I have completed the first stage using =RANK(C2,$B$2:$G$2, )+COUNTIFS($B$2:$G$2,C$2,$B$3:$G$3,">"&C$3) which if there is a tie I can resolve it if there is a difference in values in row 3.
However I can't get beyond this, in the event there is still a tie, to look at row 4 etc.
Is this possible given the data and rows available in the attached spreadsheet?
Thanks
Gordon
Bookmarks