Coming back to Excel after a few years away, so....
I'm creating an Archery Competion results, I have =IF(D3="","",RANK(H3,H$3:H$10)) the final score to set them in 1st, 2nd, 3rd etc but, in archery, joint placing is then determined by Gold hits, and if that doesn't resolve it, then actual Hits...