Sort Data In Range. To change the order of your data sort it. The Excel SORT function extracts and sorts a list of unique values from a range.
Start the excel macro procedure. Determines the values to be sorted. SORT belongs to the group of Dynamic array functions.
Line 3 specifies the sort range.
After sorting is applied the records in the range are reordered accordingly. The result is a dynamic array that automatically spills to neighboring cells vertically or horizontally depending on the shape of the source array. The other is sorting by descending ignore letter case. Click the Data tab from the ribbon.