Chapter 4: Working with Excel Ranges and Tables
4
You can sort on any number of columns. The trick is to sort the least significant column
first and then proceed until the most significant column is sorted last. For example, in the
real estate table, you may want to sort the list by agent. And within each agent’s group,
sort the rows by area. Then within each area, sort the rows by list price. For this type of
sort, first sort by the List Price column, then sort by the Area column, and then sort by the
Agent column. Figure 4.22 shows the table sorted in this manner.
FIGURE 4.22
A table after performing a three-column sort