Searchable and Dependent Drop-down list in Microsoft Excel
HTML-код
- Опубликовано: 17 сен 2022
- #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...
The best tutorial on this topic that I have found. Extremely insightful and useful, especially if you work with these kind of things 👌🙏👌
Thanks for your valuable feedback🙏
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
Wow! It’s for children! ))) make it !
This is one of the best tutorials I have watched so far. Thanks for sharing Sir.
Glad it was helpful!
Thank you for the great video on drop drowns with new 365 features. I learn so much from you PK.
Most welcome
Very nice and helpful video, thank you very much
You are welcome
It's very useful and easy to understand. Thank you so much.
Glad to hear that!
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
You are genius.. I learned lot from you..Thanks a lot sir.
Most welcome🙏
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.
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.
@@purpleparadise2001 Can you give me a formula example regarding the use of offset and counta to make a dynamic array?
A valuable learning today. Thank you
Most welcome🙏
This is great stuff! Thank you!
Most welcome
Thanks for sharing your knowledge.
My pleasure!
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)
Very helpful video. Thank you.
Most welcome
Thank you PK for this great video 📹 👏
My pleasure
Can that be applied to make multiple dependent drop down list for example 5 or 6 levels?’
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.
Thanks for this amazing video.
Most welcome🙏
Thank you so much
Very nice tutor video
You are most welcome
Thank you so much, Sir.
Most welcome🙏
It's too good. Thanks a lot.
Most welcome 😊
very great video. can this be done in other excel versions?
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?
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!
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
Hi pk, Pk utility tools, there have been you mentioned Searchable Dorp down list, it's not working, kindly check
the dash board has a bar chart and data table please help is to create it especially the data table thanks
Great post
Glad you enjoyed it
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.
List is not showing names by pressing the any letter and not fetching any values i followed the same whats the error plz
Nice video sir…
Thanks a lot🙏
Very unique...need help on 1report can you help....
sir, will it only work on office 365?
will this work on normal excel ?
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
boss please provide a business management system in vba Excel
Great suggestion! I will try to create a video on this topic.
Good one. But I'm not getting searchable function Pl help
hi ..why Searchable list not work with me i use 365 ???
Put data in a table then try "=unique(Table1[Location])"
hii, could make formula for multiple Dependent Drop-Down Lists in Excel (on Every Row) ?
will try
It's not showing "Unique" function key in my excel-2019
It is available in office 365
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.
function is in insider edition only..Which means its in testing...
@@irfanabbassi9202 ah i see, thanks fyi...
Can make chess tournament competition software
Sir it is very nice but creating formula is slightly complicated. Pl send readymade template
Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
❤💯🤟
Thanks
Dear PK Pl help
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