Unbelievable... 5 Different Drop Lists in One Single Cell

If you are a beginner in Excel, this tutorial is not for you!
If you are an Advanced Excel user, this Tutorial will blow your mind.
In this project, we go above and beyond regular drop lists. I will show you how to create 5 different drop lists in one single cell and smoothly navigate between them.
I am using multiple Dynamic array functions (Microsoft 365) and I walk you step by step building the logic of this spectacular functionality.
You can download the Exercise File and follow along by clicking on the link:
www.OfficeInstructor.com/public
If you want the items in each list to be sorted alphabetically, you can wrap the very last argument of the LET Function in a SORT Function., to read: ...SORT(Item))))
If You want to learn hundreds of amazing Data Validation Techniques, Secrets and Tricks you can read my Book:
Data Validation… a back door to… Master Excel
It's available now at a discounted price and Lifetime Updates, as a Digital Online Version (No pdf Download) at:
https://officeinstructor.com/product/data-validation-a-back-door-to-master-excel/
You can also get the printed paperback from:
www.Amazon.com
Please, support the OFFICEINSTRUCTOR channel by, liking, sharing , commenting, and SUBSCRIBING… The Best Is Yet To Come
Let's create our project from ground up in Excel…

Видео Unbelievable... 5 Different Drop Lists in One Single Cell канала Officeinstructor