Download the featured file here https://www.bluepecantraining.com/excel-automatically-sort-when-data-changes-or-added-auto-sort-excel-formula-auto-sort-macro/

Need pre-built Excel spreadsheet solutions? Try Simple Sheets - over 100 templates covering your personal and work-based needs including Gantt charts, personal budgets, employee scheduling, timesheets and more… https://www.simplesheets.co/a/45451/v7Aj9zMx

By clicking on this link you are helping to support this blog – thanks!

In this video I demonstrate how to automatically sort data when it is changed or when new data is added. The video covers the following methods:

1) Automatically sort numeric data using the RANK, INDEX and MATCH. Deal with ties using IF and COUNTIF.

2) Automatically sort text data using COUNTIF, INDEX and MATCH. Deal with ties using IF and COUNTIF.

3) Automatically sort any data in Excel 365 using the SORT function.

4) Automatically sort any data in situ using a VBA macro.
------------------------