Golf tournament with spreadsheet

Hi All

I have made an Excel file based on our recent golf outing.

There are few playes that are tied with the same Nett Score.
Tony Quik should be the Champion in Best Nett based on countback method, which is, the highest total for the last 9 holes (holes 18-10), if a tie persists, then by the last 6 holes, then the last 3 holes and finally back one hole at a time (18,17,16 etc). The same method should be applied to the Best Gross also.

The Prize Money for the Best Nett and Best Gross are different in value.
There currently 3 Catogeries during player's registratio, which is Braggers, Guest and VIP.
But, there are 4 Catogeries that we can view the results, which is Overall, Braggers, Guest and VIP.
As the Catogery's Name, we can view the results if we choose the dropdown menu.
Overall will show all the players regardless of the Category but the Prize Money will not be shown.
Braggers will only show all the players in the Braggers Category.
Guest will only show all the players in the Guest Category.
VIP will only show all the players in the VIP Category.

I would like some help with:
1) A formula that will determine the player's position based on their golf scorecard and also provide a countback?
2) How to automatically fill in the POSITION if we choose the Braggers Category from the dropdown menu, and choose the BEST NETT from the dropdown menu, only players in the Braggers Category with their position (based on NETT SCORE) and scores (PAR Column) and their Prize Money.

Any help would be most appreciated.

Thank you.

petrocelli, here is a posible start for tie and countback.
in AI8=INDEX($B$8:$AF$29,IF(COUNTIF($AF$8:$AF$29,"1")=1,MATCH(SMALL($AF$8:$AF$29,1),$AF$8:$AF$29,0),MATCH(SMALL($Y$8:$Y$29,1),$Y$8:$Y$29,0)),1)
Logic if only 1 low rank select the match in the net rank ,else select the lowest gross back nine.

Thanks wyowhite.
I will give it a try today.

petrocelli, there is bad logic in my previous post. It assumes that the back nine lowest gross will be the layer with the tie. That might be the case.
I am looking at a different approach.

In col AL-AS each net rank is tested for a 1. if it is one then the next count down is entered. the match for the lowest of the results is used to index the player. kind of brute
force.