Microsoft has included some new formulas in Microsoft Excel that I call “magic formulas”.
In today’s post I am going to introduce you to SORT.
The name already says it all. And some people might wonder: why would anyone want to use a formula to sort?
Remember the first post in this series, where I talked about UNIQUE.
Wouldn’t it be nice to have the output of the UNIQUE list of products sorted alphabetically? You can download the practice along file at https://urbizedge.blob.core.windows.net/urbizedge/SORT-%20new%20formula.xlsx
Just wrapping SORT around the UNIQUE formula, you get a sorted unique list of products.
The magic doesn’t end there. SORT allows you to specify column to sort by, the sort direction and whether row-wise or column-wise.
Below I used SORT on the entire sales report table.
You can watch a short video demonstration of it: https://youtu.be/P8vJe9iW9VU