Searchable and Dependent Drop-down list in Microsoft Excel

#DropDownlist #Office365
Hello Friends,
In this video, you will learn how to create Searchable and Dependent Drop-down list in Microsoft Excel. We have used Dynamic Array function of office 365 to create the drop-down list.
Download the practice file from the below link:
www.pk-anexcelexpert.com/sear...
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
See our Power BI Dashboard videos:
• Power BI Tutorial
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Calendar Control in VBA from below link
www.pk-anexcelexpert.com/full...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

[@alexrosen8762]

The best tutorial on this topic that I have found. Extremely insightful and useful, especially if you work with these kind of things 👌🙏👌

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@KingTechCodingClinic]

I'm grateful for having you as my mentor. your channel has really helped me grow my channel. Thank you very much PK. You are indeed an Excel Expert

[@loky787]

Wow! It’s for children! ))) make it !

[@dariuszspiewak5624]

Hi there. The raw data should be put in an Excel table (CTRL+T). Then you would have a much easier time creating references in your formulas and also you wouldn't have to worry about updating the entries when new rows are added to the table. That would be automatic. And you would be able to also type below the table(s). As it stands right now you can't do this because you've had to pass almost the whole column to your formulas. Please, when you can use Excel tables. They are much safer than just plain ranges. On top of that, I'd suggest naming ranges as well. This will then enable you to get rid of the ugly long references.

[@purpleparadise2001]

Instead of ctrl+T, we can use offset func and countA func so that we can make that as dynamic array result and we can name that array and can be used in dropdown.

[@SumeragiMinami]

@@purpleparadise2001 Can you give me a formula example regarding the use of offset and counta to make a dynamic array?

[@chrispinodinga3396]

This is one of the best tutorials I have watched so far. Thanks for sharing Sir.

[@PKAnExcelExpert]

Glad it was helpful!

[@nsanch0181]

Thank you for the great video on drop drowns with new 365 features. I learn so much from you PK.

[@PKAnExcelExpert]

Most welcome

[@NooDPee]

It's very useful and easy to understand. Thank you so much.

[@PKAnExcelExpert]

Glad to hear that!

[@excelemployeeleavetracker1274]

Great video...would it be possible to make the database a table and /or name range each column then you would not need to highlight all the cells in the columns? Thanks

[@relax9286]

This is great stuff! Thank you!

[@PKAnExcelExpert]

Most welcome

[@shoryaarora1464]

A valuable learning today. Thank you

[@PKAnExcelExpert]

Most welcome🙏

[@iftekharraju318]

You are genius.. I learned lot from you..Thanks a lot sir.

[@PKAnExcelExpert]

Most welcome🙏

[@nadermounir8228]

Thank you PK for this great video 📹 👏

[@PKAnExcelExpert]

My pleasure

[@humayoonshah6157]

Very nice and helpful video, thank you very much

[@PKAnExcelExpert]

You are welcome

[@olusholaganiyu7678]

Thanks for sharing your knowledge.

[@PKAnExcelExpert]

My pleasure!

[@pushpajchougule8316]

very great video. can this be done in other excel versions?

[@user-pu9kr7ew3l]

Very helpful video. Thank you.

[@PKAnExcelExpert]

Most welcome

[@SyedMuzammilMahasanShahi]

Thanks for this amazing video.

[@PKAnExcelExpert]

Most welcome🙏

[@MohAboAbdo]

Thank you so much, Sir.

[@PKAnExcelExpert]

Most welcome🙏

[@Yorumcu63]

Great video Thank you. Coud you make a video about stock control in same codes.I mean Have products have some input materials buying from firms and some selling records to another firms .We need check stocks (total inputs in a line and total sells in a line and stock quantity in our stok for same material Thank you

[@goodstudent5887]

It's too good. Thanks a lot.

[@PKAnExcelExpert]

Most welcome 😊

[@mygunsmile1]

Thank you so much Very nice tutor video

[@PKAnExcelExpert]

You are most welcome

[@abdullahquhtani4247]

Can that be applied to make multiple dependent drop down list for example 5 or 6 levels?’

[@dareoluwakemi]

Good evening Pryiendra Kumar Which formulas can we use in place of UNIQUE, FILTER AND SORT in earlier versions of Microsoft Excel (2016 to be precise)

[@sprucesteven]

Thanks. Can I have the formulas you used the filter and unique for all the steps. I find it difficult to see the formula used.

[@thamilanban]

Great post

[@PKAnExcelExpert]

Glad you enjoyed it

[@user-yz1hv3cy2n]

Hi pk, Pk utility tools, there have been you mentioned Searchable Dorp down list, it's not working, kindly check

[@qistiq]

Hi, may I know if the searchable feature is limited to Excel on Windows? I can't seem to get that to work on my Mac. Thank you!

[@pandharinathjoshi6565]

Nice video sir…

[@PKAnExcelExpert]

Thanks a lot🙏

[@sahedexpress433]

boss please provide a business management system in vba Excel

[@PKAnExcelExpert]

Great suggestion! I will try to create a video on this topic.

[@kiranarya771]

Very unique...need help on 1report can you help....

[@a-factoracademy]

Sir PK I'm thinking of creating a whole school report, attendance register using Excel with functionality of password for individual user teacher... Please can this be a possibility in Excel 2013?

[@ajayidamola2696]

the dash board has a bar chart and data table please help is to create it especially the data table thanks

[@satyenshukla3823]

Good one. But I'm not getting searchable function Pl help

[@mirceabarb]

What is the code for the task from 01.09 to 01.14? What order should be given? ..."tar"?? I don't understand what needs to be done to make the selection appear after the letter.

[@muhammadtouqeer8382]

will this work on normal excel ?

[@ruchitradia7063]

Hi Is it possible to apply, graphical view for the dynamic data here? can you check and guide on it? so basically the graph applied will also be dynamic

[@AjaySharma-em2ez]

sir, will it only work on office 365?

[@shinminah_1029]

hii, could make formula for multiple Dependent Drop-Down Lists in Excel (on Every Row) ?

[@PKAnExcelExpert]

will try

[@saeedwizkid]

List is not showing names by pressing the any letter and not fetching any values i followed the same whats the error plz

[@labongple5593]

❤💯🤟

[@PKAnExcelExpert]

Thanks

[@user-ue3gb4id2w]

hi ..why Searchable list not work with me i use 365 ???

[@justmusic2010]

hello sir, i have no filter here... when i type A or B or name theres no show the letter or the name i looking for, i'm using Ms. 365 Ent. Good Tutorial by the way. thanks.

[@irfanabbassi9202]

function is in insider edition only..Which means its in testing...

[@justmusic2010]

@@irfanabbassi9202 ah i see, thanks fyi...

[@sanjaydesai8263]

Sir it is very nice but creating formula is slightly complicated. Pl send readymade template

[@PKAnExcelExpert]

Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com

[@smkadri1690]

Can make chess tournament competition software

[@rodyeltabaa6871]

Put data in a table then try "=unique(Table1[Location])"

[@8147094866]

It's not showing "Unique" function key in my excel-2019

[@PKAnExcelExpert]

It is available in office 365

[@satyenshukla3823]

Dear PK Pl help

[@ajayidamola2696]

hello PK , there is a dashboard board given me difficulty the site is CDC.gov on reduced access to hearing care . can you help us create the dashboard and notify us when you are done . thanks