I have created a spreadsheet with a number of formulas linked together from different worksheets. This is for an Australian Football tipping competition where points are allocated for each of the nine games per round. Positive points are gained for a correct tip, negative points for an incorrect tip. After a complete round the winner needs to be decided, if there is a tie of points gained then a tiebreaker needs to be used to work out the winner. This is determined by whoever has chosen the closest to a margin selected. In the worksheet attached round 3 has 3 people who have each got the highest amount of points so an overall winner was determined by being closest to the margin selected for a particular game. The sheet to work off is the leader board sheetTipping draft.xlsx