TECH-006 - Create a list that automatically sorts data (alphabetically) as you enter data in Excel

YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://www.theexcelchallenge.com

Learn how to create a spreadsheet that automatically sorts data (alphabetically) as you enter data in Excel

In this video you will use the COUNTIF formula, the MATCH formula, the INDEX formula, the IFERROR formula, as well as 'Less Than' conditions, etc.

I hope this tool is something you can use in your daily routine so you get more with less effort.

If you have a challenge with Excel that you need help with, whether it is at work, at home, or at school, please write it in the comments below. I try to resolve common Excel challenges from our viewers and subscribers.

Thank you for watching.
Check out some of our previous videos in the links below:

* TECH-005 - Create a quick and simple Time Line (Gantt Chart) in Excel
https://www.youtube.com/watch?v=00s5efQWrgU

* TECH-004 - Calculate total days between dates in Excel
https://www.youtube.com/watch?v=5q_hBywbKys

* TECH-003 - Display images in comments
https://www.youtube.com/watch?v=nVdNMXp-bSU

Видео TECH-006 - Create a list that automatically sorts data (alphabetically) as you enter data in Excel канала The Excel Challenge