	Related Topics:
	Analysis Workbooks

Sort

You can sort a selected range of cells in the spreadsheet by choosing Sheet Options > Sheet Actions > Sort.

If you select Sort Ascending or Sort Descending, then the selected cells will automatically be sorted in the appropriate order. If you select Custom Sort, the Sort window will appear.

In the Sort By area you can choose how you want to sort the data: either by rows or by columns.
In the Keys area choose a key from the drop-down list, then use the Key Reference field to specify the row or column to sort by. You can select any cell in the selected columns and the sort will return the same results (i.e., if you have selected cells A1 - A20, you could use cell A13 as the Key Reference and the sorted results would be the same as if you had used cell A1). Depending on how many columns or rows you have selected, you can set up to 10 sorting levels.

For example, consider the case of sorting names and addresses. The first names are in the first column, last names are in the second column and the addresses are in the third column. In this case, you would set Key 1 to use Key Reference A1, the "First Name" column, and set Key 2 to use Key Reference B1, the "Last Name" column. If there are two of the same first names (Key 1) then the last names (Key 2) would be checked to sort between the two individuals with the same first name. If the last names are the same then the addresses would be checked, and so on.