Excel Pro Trick: Dynamic Multi Column / Multi Level Sort in Excel with SORT Function in Formula

Learn how to sort data based on multiple columns dynamically using a simple Excel formula that auto sorts when data changes. This is also called multi level sorting.

In this Excel tutorial, we are learning how to sort data using Excel SORT function. SORT function can perform multiple columns or multi level sort. Beauty of this technique is that output updates automatically if source data changes like new entries are made or existing records are altered. Excel will automatically sort the data instantly!

Lets Excel!

Access or download practice workbook file for this Excel tutorial:

For more Excel tips, tricks and tutorials don't forget to subscribe to @LearnExceltoexcel channel.

Learn #Excel your way:
===================
--------------------------------------

Pick your favourite social page:

#excel #exceltutorial #exceltips #excelformula #excelformulas #excelfunction #excelfunctions #sort #excelsort #excelsortfunction #sortfunction #sortformula

[ryanmorton]

Product names made me laugh!!
Great sense of humor!

[mohitpathak]

Easy method -Just only select 3rd row and press ctrl+l and now u can sort in alphabetical order

[mrcoolst]

This is very awesome! I can't believe I didn't know something this simple after all this time. I do have a few questions if you don't mind me asking.

At the end, do you mess up the function if you try and enter new data into the "sorted" table instead of into the unsorted table?

Is there maybe a function that automatically sorts data within a (single column) table if you enter new data in that same table, or do I just use the filter to sort it like that while entering new data?

Sorry for these questions, I think this is one hell of a useful function, and I'm definitely going to try to integrate it within my daily activities on Excel