The SORT function will sort your data without disturbing the original data set.
We’ll show you how to use the Excel SORT function with helpful examples.
The benefit of using the SORT function is that you cansort the datain a different spot.
However, if you prefer to sort the items in place, you shoulduse the sort featureinstead.
Again, this does notsort your itemsin place but in the spot where you enter the formula.
Now we’ll sort our range by the second column rather than the first.
As intended, we have Tangerine first and Apple last.
As expected, we see Yellow first and Green last.
This makes it a handydata analysis tool.
For more, check out how tosort by coloror how tosort by datein Excel.
