Sorting your data

Some functions require that data is sorted into ascending or descending order before it is processed. You may also want to sort a list of names into alphabetical order.

The Sort command provides the easiest means of doing this. It will sort rows by ascending or descending numerical or alphabetical order.

If you want to sort data that is organised along rows, not down columns, you will need to use the TRANSPOSE() spreadsheet function to swap the data around.

To sort your data:

  1. Select the rows you want to sort. Make sure you select all the columns which you want to move when sorting.
  2. Choose Sort from the Extra menu. The Sort dialogue box will appear.
  3. Enter the name of the column containing the data which you wish to sort by.
  4. If you wish to sort the data further, enter the names of other columns.
  5. If you wish to sort in descending order (i.e. highest number first) select that option.
  6. Click OK. Your selected range will be sorted.