SORT function in Excel (with 6 examples) | Learn to sort data automatically | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★

★ Download the example file:★

★ About this video ★
The SORT function is one of Excel’s best new features. It’s one of a group of functions that make use of Excel’s new dynamic array calculation engine, enabling Excel to spill results into multiple cells from a single formula.

Rather than using the sort functionality from the ribbon, which needs to be manually repeated over and over, we can now use the SORT function to do it automatically.

Through 6 examples, you will learn how to master this new function.

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel #ExcelOffTheGrid

[tizianofortin]

One of the best tutorial I have never seen: very clear and effective.

[blue-oceandreamer]

Illustration that audience/student shall find it simple and clear to follow. The English articulation is excellent. Thank you!!

[zakeermohamedkhan]

Excellent presentation with more examples

[tcplzwh]

Wow wow wow. I learned a ton very quickly today. I immediately put this in my T Shirt inventory workbook to rank my shirt designs by topic/folder name, from highest number of designs per topic to lowest, then alphabetical. I have been doing this manually every time I add a design, which is tiresome and tedious.
Thanks so much for the great instructions to make this function clear.

[RossMaynardProcessExcellence]

Brilliant video. The clearest I've seen on SORT. I'll be checking out your other videos on the new Excel functions

[sobysonics]

great video, i appreciate your composite function examples

[MrEdwardhartmann]

Excellent video. You have over 12K views - you should have over 12K likes.

[shiffamohammed]

Thanks a lot Mark, for amazingly clarified tutorial.

[richardgordon]

Thank you! Much appreciated! Very useful video!

[stefanbreytenbach]

an issue i have found is that when i try and sort cells that have data that as been aquired by formulas it gives a spill error, it works fine if the data is just simply typed in but as soon as i try and sort cells that use formulas to get that data it isnt happy, is there a way to work around this?

[mehmetdogu]

can you do 10 rows with numbers 1 to 100 to sort?

[mehmetdogu]

i had 7000 rows with 5 column only numbers no text data, sorting ascending order, it did not work at all.

[golammoulashafi]

Sir, I use Office 2019 but the short formula is not seen here. I will benefit if the solution is given.