Searchable DropDown List in Excel The Easy Way

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=Ea_ACp5W8zI

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

#############################

New on site