Auto sort golf tournament spreadsheet

Dear Tim,

Please find attached the revised file, when you feed in point in your sheet, the sheet Poiint Table will sort the teams w.r.t Total Net Point automatically.


Regards,

LEO73PK,


If someone was able to help with your question, please click on the icon at the top of their post that looks like the Scales of Justice

If your problem is solved, please update your post, otherwis

@ Marcol,

I have reviewed your solution you wrote a quite comprehensive macro for the golf sheet, i also used a macro to do so if convenient for you would you see that file which i enclosed and have a look at macro and comment if it has any limitation as far as i felt it is doing the job. But for my understanding if you appreciate & comment.

I hope your response would also be beneficial for timparker to understand the difference between two solutions available with him.

Regards,

@ leo73pk
Your workbook doesn't appear to have a macro in it, that's why I posted a macro alternative I assumed your solution was formula based.

You have posted a .xlsx workbook, that cannot contain macros, and will delete any you may have used, when saved.
You should have recieved a warning to that effect.

Did you mean to save your workbook as a .xlsm file?

@ Marcol,

Accept my apologies, there was some error in saving file i'm just enclosing the file with MACRO, kindly review as its also sorting as soon as the scores are updated in the sheet!1,

and advice, if any, limitation in this macro.

@ Marcol,

Thanks for the detailed reply in an expeditious manner.

In fact my macro is with the consideration of ranking on two parameters. In case the Net Points are same for two or more players then the next criteria will be Gross Points which automatically covers the impact of his column Handicap. (But you are right we both are not familiar with this Golf Scoring i.e. Handicap).

So lets wait for Tim's reply to further explain his requirement & the field "Handicap".

Thanks again.

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.

Hey thanks everyone this is definitely what I was looking for, thanks for all the options!

Hi #outoftheheat, or anyone else as this is an old thread
is there any simple help in "reversing the order

I would like to use this sheet which is excellent, for stapleford scoring but cant quite understand the logic to the ordering (formula interpretation) and hence is someone gets a score that would go into round 1 of 38 then they would be ranked higher than 36 or 27 etc

Please see the attached spreadsheet that I have created.
I need to be able to create a team results tab that will combine round 1 and 2 for a total gross score and then list the top 4 boys and top 2 girls from each school.
I would also like to have an individual gross score tab that would give me an overall leaderboard for boys and girls after day 1 and day 2.
Any help you could give would be awesome.
Thanks.
Joey