Sort employees by hire date with SORT
IntermediateWhen a table has dates, names, scores, or other values, SORT can create a live reordered copy without changing the original data. SORT is a dynamic array function, which means one formula can return a full reordered table that spills into nearby cells automatically.
SORT uses this structure:
=SORT(array, [sort_index], [sort_order], [by_col])
The array is the full range you want to sort. The sort_index is the column number inside that selected range, not a worksheet column letter. The sort_order is 1 for ascending and -1 for descending. The optional by_col argument changes the direction of the sort: leave it out or use FALSE to sort rows, which is the normal table behavior.
The sort_index must point to a column inside the array you are returning. If you need to sort one range by a separate range outside that table, use SORTBY instead.
In this sheet, the employee table is already filled in for you. Create a sorted copy in the output area so the list is ordered by hire date with the newest employees at the top.
Your task:
Enter one SORT formula in A11 that returns the employee table sorted by hire date, newest first. Let the result spill through the output range automatically, rather than typing into the other cells below or to the right.
Need some help?
Hint 1
The hire date field is the fourth column inside the employee table range, so the sort_index should point to column 4 within the selected array.
Hint 2
To show the newest hires first, use a descending sort. In SORT, that means the sort_order argument should be -1.
Sort employees by hire date with SORT
IntermediateWhen a table has dates, names, scores, or other values, SORT can create a live reordered copy without changing the original data. SORT is a dynamic array function, which means one formula can return a full reordered table that spills into nearby cells automatically.
SORT uses this structure:
=SORT(array, [sort_index], [sort_order], [by_col])
The array is the full range you want to sort. The sort_index is the column number inside that selected range, not a worksheet column letter. The sort_order is 1 for ascending and -1 for descending. The optional by_col argument changes the direction of the sort: leave it out or use FALSE to sort rows, which is the normal table behavior.
The sort_index must point to a column inside the array you are returning. If you need to sort one range by a separate range outside that table, use SORTBY instead.
In this sheet, the employee table is already filled in for you. Create a sorted copy in the output area so the list is ordered by hire date with the newest employees at the top.
Your task:
Enter one SORT formula in A11 that returns the employee table sorted by hire date, newest first. Let the result spill through the output range automatically, rather than typing into the other cells below or to the right.
Need some help?
Hint 1
The hire date field is the fourth column inside the employee table range, so the sort_index should point to column 4 within the selected array.
Hint 2
To show the newest hires first, use a descending sort. In SORT, that means the sort_order argument should be -1.