You can sort data by column and restrict the results to a specific number of records. Therefore you can apply multiple sorting criteria to a specific worksheet in a specific order. The results are displayed on a new read-only sheet or sorted directly on the current sheet. Sort sheets aren't automatically updated when the original worksheet is updated. If functions are used on a worksheet that is sorted, the sorting of a worksheet is the second action executed after the functions being executed. |
Sorting works best with small, aggregated results, and reliable results are not guaranteed for distributed data. For large datasets, use the GROUP_SORT_ASC and GROUP_SORT_DESC functions. |
To sort data:
To revise sorted data:
To sort columns quick:
After a worksheet is sorted, it is labeled as a formula sheet. You can add additional formulas to the sorted sheet. |