Page tree

Welcome to FreeSoftwareServers Confluence Wiki

Skip to end of metadata
Go to start of metadata

Drop Down List - Searchable

Options:

* Use Formula (O365 Only) (Requires Helper Cell)
https://www.xelplus.com/searchable-drop-down-list/

* Use VBA

https://www.excelcampus.com/add-in/list-search-april-2017-update/

* Use Pivot Table
https://www.myonlinetraininghub.com/searchable-drop-down-list-in-excel
Worked great, but two things, requires helper column and shows (ALL) by default

  • No labels