Excel - Searchable Data Validation List without VBA (Dropdown) | XL Studio
Office 365 and Office 2021 comes with dynamic array functionality and excel calculation engine is completely changed. Creating Searchable Data Validation is more easy now using dynamic Filter function.
To Create searchable data validation we can following formulas
Filter() (This is new dynamic array function)
Search() (this function use to get the position number of keyword)
IsNumber() (this function use to convert numeric to True else False)
Sort() (This is new dynamic array function)
=====================================================
Thank you so much for watching
Please Subscribe to my Channel and hit the bell icon to get notified with my upcoming videos
=====================================================
#XLStudio | #Excel | #searchableDataValidation #DataValidation | #dropdown | #Filter | #Search | #IsNumber