Forum Discussion

FrankWitsel's avatar
FrankWitsel
Copper Contributor
Feb 28, 2021

Excel Sort function on the active range

Hi guys and girls, I'm new here and I'm not an inexperienced Excel user. BUT, I have a challenge with a Table with 11 columns in where I like to automatically sort (ascending) the whole data (numbers...
excel
Excel on Mac
office 365
mathetes's avatar
mathetes
Silver Contributor
Feb 28, 2021

There's also a new Dynamic Array function SORT which you could use.

Keep the existing sheet, with the data established as an official Excel Table.
Then use SORT on a second sheet to produce a sorted version of that Table
Do all your additional rows in the original (unsorted) table. They will automatically be added to and resorted in the second version. It's basically separating the raw data (Input) from the Output.

 

Here are two resources to learn more about SORT and some other of the Dynamic Array functions.

https://www.youtube.com/watch?v=9I9DtFOVPIg

 

https://exceljet.net/excel-functions/excel-sort-function

 

Resources