In Sort On More Than Three Columns, I described how to short your data in two steps. Mark’s tip for sorting on more than three columns uses a helper column.
Using another column, you can concantenate the columns you want to sort and sort on that column. This example sorts on four columns by using a fifth column to string together the other four.
There is a problem with this method. In the screen shot below, Dick’s week 5 entry is sorted above John’s. The ‘Number’ column is coverted to text in the concatenation process and 18 is less than 5 when their both considered to be text. Text is sorted by comparing characters from left to right.
So be careful if you use this method. Thanks for the tip, Mark.