Ranking with Tie-breaker for Fishing Tournament

Hi All,

New to the forum. Having read numerous other posts I have managed to cobble together the attached spreadsheet for a fishing tournament. It currently does the following:

1. Allow anglers to records weights against respective peg numbers over a three day period

2. Allocated points (lowest for highest weight) per section

3. Creates a summary sheet with the results per day and total weight/points over the three days.

Ideally I would like to add a tie-breaker to the final points ranking if possible and also have a list of anglers and their final ranking (with respect to points and weight where a tiebreaker is required) which is sorted in ascending order.

Any help, advice or insights would be gratefully recieved.

Thanks, Paul

Thanks AliGW, that's great!

Hi AliGW,

Just been having another play with this, not sure it has quite solved it. If a tie on points exists the person with the highest weight (lbs + ounces) to assume the higher ranking number.

On the sheet the formula is ranking the person with the lower weight higher?

I have had a play with the formula but cannot get it to reverse this logic.

Thanks Paul

Thanks AliGW that's all working now. Really appreciate you taking the time to help out.

Hi AliGW,

I couldn't get the rank function to report sequential ranking numbers? If two people tied on rank 1 then the next person would start at rank 3, the sumproduct and countif seemed to solve that issue.