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?
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.
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
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.
The videos mentioned in this post combine various Excel features and formulas. Here are shorter videos that explain each concept separately.