Create a searchable drop-down list in Excel using the FILTER function. This is the easiest way to set up a searchable list.
Download the file used in the video - https://www.computergaga.com/_excel/f...

Introduction to the FILTER function -    • Excel FILTER Function - Is this the B...  

This video shows two examples of setting up a searchable drop-down list. The first example searches for what you type anywhere in the text of the list items.

This is great when searching for people's names as you can search using the first or last name.

The second example will test only the characters at the start. The example here is to search for countries in a list. When you type 'Ca' you want countries like Canada and Cambodia to appear, not South Africa although it does contain the letters 'ca'.

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J

Connect with us!

LinkedIn ►   / 18737946  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1