Searchable Dropdown List in Excel || Filter Function || Single Formula

In this video, we will discuss about how to create a seachable dropdown list in excel. Searchable dropdown list will be made with very easy method with only one formula. Following MS Excel functions were used in the video
#Filter()
#Sort()
#ISNUMBER()
#Searchable Dropdown List
_____________________________________________
www.baljeetsin...
_____________________________________________
Connect with me 😀
Follow me on Twitter - / mbaljeetsingh
_____________________________________________
COURSES 💻
Ionic 4 - Build PWA and Mobile Apps with Angular -
www.udemy.com/...
Wordpress Rest API and Ionic 4 (Angular) App With Auth - www.udemy.com/...
Angular & NestJS - The Modern MEAN Stack Guide -
www.udemy.com/...

[@ramkumaryadav2053]

very good

[@rajadey1552]

Wow bohot easy process bataya sir aap wow awesome 👍

[@rajeshwarpaulgaming3338]

Great video Sir.. 1 line code dropdown list pe autosearch. Isse better solution ho hi nhi skta. Aapne bahut bada help kr diya.. 👍 subscribed!

[@dibyasinghroutaray3656]

Great job sir Sir my question is about how to see the searchable list without using alt+ ⬇️ or click on the drop-down button. The suggestion list should be displayed automatically

[@mauryabri]

VERY NICE VEER JI

[@javedahmed8343]

What a cool way of explanation!!

[@rosariocoutinho8690]

Thank you very much. Good explanation. Can you make one video with searchable dependent list for dependent drop down list. Depending on place list of names of persons from that place should come. On selecting a person name then his details should come. I think we need vlookup also here

[@zeshanshahid8591]

Paa G great

[@fahadkhalid8924]

It's only work for specific excel version?

[@umeshjawalikar4913]

Good

[@munibsayed6433]

Can we use this searchabledropdown list or data validation for another sheet in the same workbook

[@Zunaid]

sir excel 2013 se filter option show nahi ho raha hai

[@muhammadshahbaz7294]

Will you make another video for drop down searchable list with unique items please

[@ketanb7994]

Hi Baljeet, what if someone will not select from drop down option and mention incorrect name, meaning instead of selecting from drop down option for Sea, person mention Sae text and save the file. How we can restrict a person to select the name from the list or incorrect name is not allowed?

[@swethasingapuram456]

Thank you, can you please provide a solution for searchable dropdown list for dependent drop down list.

[@mohitkataria1675]

What about incase we need to create searchable drop-down for numbers?

[@pankajknowledgeworld]

जैसे मेरे पास 2016 h फिल्टर function नहीं है तो जो data मे filter option h उससे भी हो सकता है क्या

[@subhra134]

One cell drop down showed, how it works for down cells, suppose next row finding another name

[@iqbalsingh6311]

Available only in Microsoft 365

[@mnvlogzzz5856]

Filter formulaa show nhi hora mere excel sheet me mera excel 2013 ka hai

[@iqbalsingh6311]

Filter formula only available in Microsoft 365

[@karansheth4541]

@@iqbalsingh6311 filter jagah kya use kee

[@mnvlogzzz5856]

Plz reply

[@poonamdhanawade2606]

Not useful, data validation in not consistent for cells below that single cell.

[@mukeshbihat]

Good