Sort

sort3This Analytics Edge wizard lets you create one or more sorting rules which will be applied in sequence to order your data.

If two rows are equal in value for the first rule, the next rule is used to determine the order. You can specify as many rules as required.

Column – select a column by column letter position (optionally by Name).

Sort On – select a sorting option to use, optionally check Case sensitive to order upper and lower case letters differently.

Order – select whether to sort ascending or descending order.

Add Rule – adds the selections above to the sort rules list. When multiple rules exist, they will be executed in order; if there is a tie in the first rule, the second rule is used to determine order.

Delete – remove the selected rule from the list.

Up / Down – move the selected rule up or down in the list. The rules will be run in order, so the first rule has highest priority.

sort all numeric columns in ExcelIf your table consists of a series of numeric columns, you can optionally auto-sort all of them, with an emphasis placed on the first or last column, in ascending or descending order.

This is usually done in trend reports, with the highest value in the last period, and equal values ordered by the previous period numbers.