Excel Create Dependent Drop Down List Tutorial
Вставка
- Опубліковано 7 вер 2024
- A Quick Excel Tutorial of Dependent Drop down list (The options in the DROP DOWN list changes based on the cell value)
🔶 Get Excel File at : bit.ly/34Nqblq 🔶
Products:
🔷 gumroad.com/te... 🔷
Recommended Gadgets/Products:
www.amazon.in/...
Check the below Playlists..
Excel Tutorials:
• TEKcel Series : Excel ...
Excel Chart Tutorials:
• TEKcel Chart Tutorials...
Excel Pivot Table Tutorials:
• Excel Complete Pivot T...
Excel Gsuite Tutorials:
• Gsuite Tutorials
Excel Tips & Tricks:
• TEKcel Tips : Excel Ti...
Powerpoint Tutorials:
• Tekpoint Series : Powe...
App Reviews: • Apps
Gadget Reviews:
• Gadget Reviews
Thanks for watching!!! 😊🙏
Please do Subscribe and Hit the Bell 🔔icon to support my efforts and to receive all my videos Notifications.
CLICK HERE TO SUBSCRIBE 👉 tinyurl.com/Te...
Follow me on below to stay connected👇
👉FaceBook: / teknisha
👉Instagram: / teknisha18
Clear, simple and quick.
Thank you very much! So much better than the microsoft instructions!
Glad it helped!
Crisp without unwanted stories. You rocks
OMG greatest solution ever... just look the other solutions over there for this same problem... you couldnt be more efficient! u made my day :)
Glad that this solution helped you. I have also made another version. You can check that too. ua-cam.com/video/xph7wrqN8QY/v-deo.html
Wow!!! Sorted out like 90% of the problem I had, now the second column upon changing the first one.
And finally it was the $ thing which was not allowing copying in the multiple cells.Thanks for sorting that out
Very simple and easy that many people make it complex....Thank you!
Glad it was helpful!
I was confused for not getting dependent dropdown correctly, and you just tell exact reason of removing $ from column and cell number.
Thank you.
Thank you very much my brother, this is what I have wanted to know since a month ago. 🙏🏾🙏🏾🙏🏾
Thank you, your information was very helpful, although I encountered some difficulties with titles containing multiple words (which I resolved by inserting underscores "_" between the words).
Thanks for your simple uncomplicated explanations... ❤️❤️❤️
Thanks you did it simple to explain.
How to remove the blank in drop down? Instead of offset
Excellent ! Short & sweet and to the point.
Thank you
Short but extremely helpful, thanks a lot.
Glad that this helped you
I am watching after 5 years of upload, thanks. It's useful
great video! Direct to the point and very clear. Thank you!
Glad that this Tutorial helped you
Thank you! I managed to create the dependent list in excel :D
Awesome. Happy that this helped
I learnt from your UA-cam channel. Great. Good Teaching. This is the easy way.
TO THE POINT EXPLINATION , REALLY HELPFULL . TYSM
Thank you so much for demonstrating the simplest way of doing this. Much appreciated. Keep up the good work 👏.
Liked your video, just what I was looking for.
Glad that this
Helped
Thank you very much Sir, very well explained and uncomplicated...
Thank you Sir, video was really very helpful & easy to understand
Glad it was of help
Thank you so much! It was exactly what I need it.
Glad that you liked it
thats a good yet not much a sufficent application. you could use the Indirect with Match, Char and CountA to set the range of the second combobox.
Super quick explanation with systematic approach...
you skip the video how dependent drop down list creates
A drop-down list with 10 names. in line 1 choose name number 1, in line 2 do not show name number 1 because it was selected before. continue like that until the end. can this be done?
Yes, it can be done.
You have to highlight the preferred column where you want the data validation to occur and apply the data validation in the column.
E.g if you want the data validation to have effect in column D, you need to highlight the whole of column D and apply the data validation
Nice video, but the method of adding blank cells to the range in case of additional values is sloppy and doesn't presentation t well. instead make the named range dynamic by using an OFFSET formula and COUNTA
How to put price break up chart for jewellery website in discription column for each product also if possible it should be linked with next coloumns values dynamically in excel.
Outstanding! Hi from Limón, Costa Rica!
Glad that you liked it
Sooo nice my dear. very simple thank you so much. you are a nice teacherrrrr
Nice video, Good speed and time management. Crisp and clear...Thank you
Thank you...
Hi Nice Simple Vid but just to let u know I had issue going forward after removing both the $$ symbols, its only after I kept the 1st $ Symbol before ColumnG and removed the 2nd $symbol, i was able to proceed
Thanks Buddy the video is very much useful for my exam purpose
Thanks for this. Very helpful.
Great video, other channels drag this on for 18 minutes.
What if the first drop down had names with spaces? Like 'Green fruits" and "Orange fruits"? Named ranges cannot have spaces
Thank you George. Check my updated video for the multiple dependent drop-down list. In this method you can use names with spaces.
ua-cam.com/video/xph7wrqN8QY/v-deo.html
Great video, I need this tutorial for a personal project. Thank you
Hi,
Instead of dependent drop dow, can we get both fruit & vegetables in same list under names using expand & collapse.
Eg: Fruit-> expand -> names & Vegetables -> names
Thanks for the Video. Also i want to ask you something in case that i have make an error with the selection of second list , how i could change the selection which created at first?
Thanks for the video
What if I have to chose only 3 options out of 5 in the drop down skipping a cell. Example 1 3 and 5 how do I do it
I watched many videos but this is great ...
Thank you for the video! It definitely helped however I would like to know if I am able to select the 1st level and have the 2nd level automatically inserted on the 2nd level instead of having it as a drop down? Which means once I select the 1st level, I do not need to type out the 2nd level as I only have single text to display. 😊
Glad that you liked it. Yes it is possible to pull the 2nd level text. For this you need to use a lookup method like index/match or vlookup. All your first level and respective 2nd level information needs to be in a table and then you can use a lookup method to populate the 2nd level based on the 1st level chosen
@@TEKNISHA oh no, I have not done those you mentioned before... I'm clueless! Can tou shed some advice here... thank you so much!!
You are the best. Thank you.
Happy to help!
Thanks for it. It's working soo good.
You are welcome
Straight to the point. thank you !
Thank you for the this video.
How can i put the color automatically once i choose particular type? 😊
Can you please searchable dropdown list that works for version 2019 or older
thank you! you solve my problem!
Great. Glad that this helped
After creating the table, can I delete the selections on the left where you highlighted yellow? Will it also delete thr selections if I delete them?
Very simple explanation. Useful to me.
it is so much easy. i really liked it.
how to make condition if we change the type column it will automatically emptying the name column ?
I have a simple list in cell A2 its values are “Yes” and “No”. I want this cell A2 as mandatory; mean it should never be empty. But a problem is there, when I press delete from keyboard, it deletes list element from said cell and no error is displayed. How can I do it without using VBA?
easy to learn, thankyou Mr. Teknisha~
Nice one! Thanks!
You bet!
Very easy to understand but I have a problem with the indirect function the other day I wanted to do it, it was saying there is a problem with the formula so I was thinking maybe it's the version of my Excel
Thank you ❤
Very good video, didn't beat around the bush but quick & easy with good instruction. thanks for sharing & will subscribe to your channel
Thank you jim
very quick and clear,tq Sir
I love this it is very applicable
Happy that this helped you
Maybe I'm doing something wrong, but this list doesn't seem to be dynamic. Rather it seems to look at the cell you type for indirect for. So, that means the first one will be fruit and the second will be vegetables even if you select fruit again.
Encountered the same issue.
It gives an error for me. 'The source currently evaluates an error'. Method Does not work shows error after indirect step.
thank you so much for your video & it does help me alot
Nice 😊👏👍teaching sir, tq for your support.
Brilliant! Thank you.
Glad that it helped
Very helpful 👍 🙂
Glad that this was helpful
Thank you so so much for this video
Thanks a lot
Glad that this helped
Question is how to do this in sharepoint excel file :d, cuz when you try to rename that "array"... it shows you msgbox you cant do it
Thank you bro. It is working.
Please answer this., How can we add space while naming the table.
I want to put the list data in second sheet but the source option is not going in second sheet
Thank you sir for nice and clear video, I have a question pleas. I make a table that contains in culomn A doctors names and the headers in row1 is the month date. Inside the table all the cells has data validation with departments in hospital to make a monthly rota shift for the doctors. The list of the data valedation contains (main department, long shift, short shift, emergency, operation room, DAY OFF).
I want to make a conditional FORMATING THAT IF I CHOOSE "long shift" from the data validation automatically gives this doctor "DAY OFF" for the next day and color the cell of "DAY OFF" in red.
How can I do that.( For example if I choose in C5 "long shift" automatically mak D5 "DAY OFF" with red background in B5.) thank you.
There’s a better way to do it without blank rows. But your video helped a lot
I like your information video. Send me more info. Thank you
Short & excellent
Thanks for putting this up
You are Welcome
Thanks
Thank you
Sir can u make a video how to unlock file when 2 people save workbook at the same time
Thanks for sharing.
Thanks for watching.. Hiren Patel
Very useful
Can the data be on a seperate excel book from the dropdowns?
What is the short cut key to use drop down list??
But in data validation we only e showing text not with his format which is used in data base?
How can we use data validation with test als well as format ?
I have a problem by doing the excel, menu scroll down menu and in the same time a name appear auto scroll up for the name that we chose in the other of the scroll down menu,
Excellent👍👍👍
thanks...
If we are changing first column data don't get changed in second column
Same
It does, you need to select the range and then whenever you change the data it changes in the second column
Excellent bro
Thanks...
You're welcome!
Very very good!
Thanks Brother
Happy that this helped...
How to use indirect command when data is on sheet 2
Thank you so much sir...
Supper
explanation and very helpful
❤thank you very much. 🎉
If the data spelling is been spaced, the dependent list is not working. I mean for example - Information Technology will be main type and then the dependent list will be IEC material. Then I tried to link with data validation but it is not working. After I left space between Information and Technology, it is working. If you have any idea, please let me know.
not working
Thankyou
amazing, excellent job