Auto sort golf tournament spreadsheet

To do it without macros, see the attached.

I've added 2 columns on the left-hand side of your input sheet (sheet1). First column uses the RANK() function to rank by score, and adds 100th of the row number to ensure there are no ties. (works for 98 players as set up - if you want it to work for 998, just divide row by 1000 rather than 100), and second column uses RANK() to give a unique position number.

On the Standings sheet you'll see a table that uses the Rank column on Sheet1 with VLOOKUP to display the players in ranks order (first row looks up rank 1, second looks up rank 2, etc). I've set it up so that where there's no data it displays "-", using IFERROR().

Now all you have to do is type in the scores on Sheet1, then they'll be ordered on the Standings sheet.