Custom Sort Order

Submitted by Wei Jiang of Shiyan City, China. Jiang is a consultant for MrExcel.com.

By default, Excel enables you to sort lists numerically or alphabetically, but sometimes that is not what is needed. In Figure 13.10, the client needs each day's sales data sorted by the default division order of belts, handbags, watches, wallets, and everything else. This sample uses a custom sort order list to sort a range of data into default division order. The results are shown in Figure 13.11:

Figure 13.10

Unsorted list in Columns A:C and the custom sort list in Column I.

0 0

Post a comment