![]() If an item exists multiple times in the source list, the dropdown list will display all items regardless of repetition.Īlthough all the above-mentioned issues are worth investigating, this post’s focus is on the searchable aspect of the Data Validation list. ![]() The list does not automatically suppress duplicate items.Locating a specific item in an unsorted list can be both tedious and time consuming, especially when the list contains hundreds or thousands of items. if new items are added to the list, the list does not automatically re-sort. ![]() What do we mean by a searchable Data Validation list? Let’s look at the example below.Ī traditional dropdown list provided via the Data Validation tool displays a list of items from a predefined list. ![]() This is a common question asked on this site and most any Excel training venue. “Does Excel have a feature to allow a Data Validation list to be searchable?”
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |