Hide and Seek

Imagine a data validation drop down list with many names that are not sorted. Trying to find a particular name in that list would get frustrating as the list grows.

 

Did you know that there are ways to sort text in Excel?

 

Method #1

Use Excel’s sort feature.  Great option but you would have to manually re-sort the list every time you add more names to your list. 

 

Method #2

Formulas can sort the data.  It’s a great option but it does take time to build the dynamic list using formulas. Watch my video below.

 

Watch my YouTube video

 

Download my Excel file

Download here or via my OneDrive (file 00064)

 

Wait!  There’s more!

Imagine your list continues to grow and the constant scrolling down the list is driving you crazy even though your list is sorted.

 

Select the 1st letter of the last name to see a shorter list!

This is possible using formulas.

 

Watch my YouTube videos

Select first letter to create a mini list

 

Data validation connects to formulas

 

Yes, it definitely takes time to learn how to create more advanced solutions but it can save you hundreds of hours over the long term.

 

Subscribe to my YouTube channel and learn more!

See my free templates here!

 

Related Videos:

The videos mentioned in this post combine various Excel features and formulas. Here are shorter videos that explain each concept separately.

Data Validation, Array Formula, Sort Data

Post a comment