A client had a tennis scoring spreadsheet with different sets of data for different divisions on the same worksheet. Players on equal points are thereafter ranked on best games difference, then games won and then head to head.
Whenever he created a sort, then sorted another division, the sort order of the previous division was not remembered and if the data changed, he had to re-input the sort criteria.
This is a useful example of when it is worth formatting data as a table. I created a different table for each division by selecting the relevant data, then on the Home tab, in the Styles group, from the Format as Table dropdown, selecting a table format I like.
Select the required sort order, then click OK.
When you revisit any of the tables and click Data – Sort again, the required sort order will be kept and clicking OK will re-sort the table.
Find out more about our Microsoft Excel training London, UK.
Find out more about our Microsoft Excel training Wiltshire, Hampshire, Dorset.