Sort Within Worksheet

 

Menu location: Data_Organizing_Sort_Manipulate Worksheet.

 

StatsDirect enables you to create sorted copies of worksheet columns or to manipulate data within a selected data range of a worksheet. This section deals with sorting data within existing ranges of data that you select in a worksheet. See also sorting columns.

 

PLEASE NOTE that for this function you should not select columns by clicking on the headers of the columns. Select only the data ranges that you want to sort by dragging the mouse across them with the left hand mouse button held down.

 

This function manipulates selected workbook data ranges by sorting the data. Sorting may be ascending or descending and either up/down columns (by row) or from side to side (by column). You select a key which is the cell where you want the sorting to begin and in the row or column upon which your sort order is based. Selecting more than one key enables you to perform a nested sort, i.e. sort on key one (say the data in column x) then if there are repeats of the same value in column x look in the key two column (say column y) to order the repeated values according to the order of the data in this secondary key and so on.

 

Example 1

Sorting the following data ranges ascending order by column with key as the first data cell (at value 86) gives:

 

86 ------>	68
71	70
77	71
68	71
91	72
72	77
77	77
91	86
70	87
71	88
88	91
87	91

 

Example 2

Sorting the following data ranges by the ascending order of the data in the first column by row with key as the first data cell in the first column (86) gives:

 

86	88 ------>	68	64
71	77	70	65
77	76	71	80
68	64	71	77
91	96	72	72
72	72	77	76
77	65	77	65
91	90	86	88
70	65	87	72
71	80	88	81
88	81	91	96
87	72	1	90