Sample Header Ad - 728x90

How to auto-sort a table in Numbers?

0 votes
0 answers
1875 views
I'm trying to get Numbers to "auto" sort a table when data is entered into a different table. It's for a simple round robin tennis tournament, where points are accumulated each round, and I'd like to have the players ranked after each round based on Total Points. I've used RANK and it's working perfectly to calculate the results, however, the ranking table doesn't automatically sort via the Rank Column when a new value is added in the main table on the left. This spreadsheet is being used on an iPad and the games are just 12 minutes long. So, it's not practical to have the players having to sort the column every time. Calculating the Total Points and Ranking them Is there a formula or trigger / procedure I can use that will monitor the Rank column and sort it when new data is entered on the left?
Asked by Alinoz (1 rep)
Sep 16, 2022, 09:52 AM
Last activity: Sep 16, 2022, 11:39 AM