rank order by up to 4 progressive criteria

[geemacmcm]

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