In Excel how to Sort data in Array

Loading

Requirement: Sort Data in Array

Sorting collection of string in array using the sort function in excel list.

=SORT(A2:C11, 2,-1)

By using the above formula Sales column Order were changed to Descending order

Leave a Reply

Your email address will not be published. Required fields are marked *