They are:
- UNIQUE
- FILTER
- RANDARRAY
- SEQUENCE
- SORT
- SORTBY
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
Meet SORT
Just wrapping SORT around the UNIQUE formula, you get a sorted unique list of products.
Cool, right?
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
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
Meet SORT
Just wrapping SORT around the UNIQUE formula, you get a sorted unique list of products.
Cool, right?
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
![Pin It](http://pinterest.com/pin/create/button/?url=https://www.olafusimichael.com/2019/12/new-excel-magic-formula-2-sort.html&media=https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXvfvicK6K8m4qwaHG87QY_HdQPD4E9dd8BiH662rSAlEXaYUgdX3_caZqT_uReKXFpgoLMRJURV4azg7v02-08xK_1s8ZcxqQyS_7nCqoQTw9nUsIGN4ZlyJyw5I9EbRbtSxf3WMVslc/s72-c/unique4.jpg&description=Microsoft has included some new formulas in Microsoft Excel that I call "magic formulas". They are: UNIQUE FILTER RANDARRAY ...){kind=link}
0 comments:
Post a Comment
You can be sure of a response, a very relevant one too!
Click on Subscribe by Email just down below the comment box so you'll be notified of my response.
Thanks!