unlock

Searchable Drop Down List in Excel (Very Easy with FILTER Function)

0:00
↔️ ↕️

Timecodes:

can Excel have a searchable data

validation list this is one of the

common questions I get on this channel

so here I have a data validation list

when I click on it I get the list of all

customers to find one I have to scroll

and find the name now here comes the

part of it being searchable if I type in

GA R and I click on this I get the list

of names that only include JR now notice

that it doesn't have to be at the

beginning of the name it can be anywhere

in the name if I type in Rob and I click

on the down arrow I get the list of

names that include the word Rob and if I

remove that click on this I go back to

the full list now if you look for this

online you're gonna find a few VBA

solutions

I also cover a VBA version which uses

user forms inside my VBA course but how


Related queries:


how to open excel file online
how to unlock excel spreadsheet online
how to unlock excel file for editing online
how to open excel corrupt file online
how to open corrupted excel file online free
how to open encrypted excel file online
how to open local excel file online
how to open excel file in online mode
unlock excel files
how to unlock excel online
how to unlock protected excel sheet