New Excel Magic Formula #2: SORT

Microsoft has included some new formulas in Microsoft Excel that I call “magic formulas”.

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

Leave a Reply

Business Data Analysis
close slider
[]
1 Step 1

Interested in our Business Data Analysis Training?

keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right