Thank you for the video! However my drop down list consist of data vary from 5 to 50 drop list, is there any way to delete the blank list from the drop down view? Just to make it look better and efficient, Thank you 😊
Hi Leila! I did a different approach to the solution on this video so I can account for dynamic rows, as well as no including empty cells in the second dropdown list. The only drawbacks for my solution is to use the EVALUATE function within a Name formula, and save the file as a macro enabled file. Other than that, these are the steps I followed: 1. Save the file as a macro enabled excel file (.xlsm) 2. Convert the range to a Table (CTRL+T) 3. Created a Name formula named TheList: =EVALUATE(CONCATENATE("OFFSET(Table1[",$K$5,"],,,COUNTA(Table1[",$K$5,"]))")) 4. Set my Data Validation for the second dynamic dropdown to =TheList This way, the second dynamic list will only show the appropriate number of items depending on the first dropdown list (K5), without the extra blanks, and it dynamically adapt to more/less rows. I hope my above explanation makes sense.
you can avoid evaluate (based on Leila references) name TheList based on formula : =OFFSET(Sheet1!$A$4,1,MATCH(Sheet1!$G$4,Sheet1!$A$4:$C$4,0)-1,COUNTA(OFFSET(Sheet1!$A$5:$A$20,0,MATCH(Sheet1!$G$4,Sheet1!$A$4:$C$4,0)-1)),1)
Thank you again Leila! This works very well for 2-level cascading drop-downs, but if you need 3-level or 4-level (continent, country, region, province, town, street - for example), then it does not work, because INDEX is not more than bi-dimensional. Any idea on how to implement a n-level drop-down controlled data input?
Wonder why didn't MS Word allow this in word forms without having to go thru bookmarks and all that mess? And I can't find where word will allow several drop downs. I have 8 columns of data with lists within lists. Ugh! You are the best teacher!
Wow! I had no idea that you could paste a formula into the list reference box. Have wondered for quite some time how to get different lists depending on the criteria selected. Definitely using it.
Hi, Really like your explanation on Formulas. I have excel in which column A is applied with list of Country Name, Column B with list of States of each country. And i want people should see respective country's state when they select country in Column A . Pls guide. Your logic work for single cell not if i apply to entire column
Im MS Word, I need help please😊. I made an invoice using a table for data entry. I have 2 drop down list (one is a regular drop down list), and the second drop-down is a dependent drop-down list. Both drop list contain long selections. There's no way around the long selections, it's needed. How can I get it to word wrap in the cell in the table? The margins are set for each cell. I tried alsl by selecting the table word wrap under table options. Frustrated. Thanks, Jyng
Thank you so much, always so great! It helped me solve a problem of simulating radio buttons on a group of cells. I just had to find the right formula to insert in the Data Validation Form. Let me explain in some words. I designed a group of 2 cells, one containing “x” and the other nothing (you could also use “yes” and “no”…). Let say these cells are in G4:G5. Now let say my range of cells figuring radio buttons are in C4:C6. Then I create a Data Validation on each cell, allowing List and giving the formula =SI(NB.SI($C$4:$C$6;$G$4)=0;$G$4:$G$5;$G$5) (in French, sorry; change SI by IF and NB.SI by COUNTIF). It works great, without VBA!
I would have liked to put symbols instead of “x” and nothing. I found radio buttons in Windings but the drop-down button isn’t able to show characters in the right font. As I use mainly the Calibri font (but it’s the same in Arial for example), I use the character 0298 (Unicode) for the enabled button and character 039F for the disabled button. And one more info; before letting the user use these radio buttons, fill all cells with the disabled button.
Dear Leila, many thanks for your channel. Would be possible to sort the drop down list automatically? If there are lot of items, it could be hard to find needed data and would be perfect to have them sorted. Thanks
Thanks Prawin for your comment. Sure, I'll add this to my list. Multiple dependent lists would work in a very similar way as the first dependent list though.... unless your data is not structured like this....
Thanks for your response. To be precise in my request, in your above video 'Misty Wash' is dependent on 'Utility Div'. My request is, for example the next dependent should be based on 'Misty Wash' & 'Utility Div'. Like if 'Misty Wash' & 'Utility Div' is selected then 3rd dependent should show 'X' and if 'Misty Wash' & 'Twenty 20' is selected then 3rd dependent should show 'Y', etc., likewise for all.
Thank you Leila! It looks like this method is better than the other one requiring using INDIRECT(), because you do not need to define all those names... Right?
Ohhh thank you Gopala. You are very kind! I also learn a lot from the Excel community here and I am very thankful for every one watching and providing feedback on the videos.
Hello Leila, is there any way to create a table that changes based on drop down menu selections. The value of previous table should not be there when I change drop down selections. Thanks
Hi, Is there a way to make "ActiveCell"-dependant Drop-down list ? In your example you have Static Input cells.Its quite simple. What if we have a Table/ and one row of this table should have Drop-Down list based on the Lookup value from another table. given 1 cell from this table as an input for searching? any sugestion? VBA ?
Hi Leila! You're videos really helped a lot. I'd like to ask. In excel when does 'too many cell format' happen and what is the solution for it. Thanks and more power!
Hi Leila - I wonder if you can help me out. I've seen a lot of UA-cam instructions about drop down list but I don't see anything about how to create a column list. For example, I have 10 names in column A. I want to create a column list with those 10 names. Thank you for your time.
I thank you very much for this useful illustration, you are really a genius, but I have a question: how can I add an equation so that it prevents repeating the evidence? Thank you.
How would one write this if the Match lookup value was in column "A" and we wanted to see the values in column "B" and "C" that correspond with that lookup value. Following your example if my selection list was "A5:A19" instead of "A4:C4" and I tried to return Jellyfish and Atmos when looking up "Mirrr" what would be the equation? I tried; =Index($B$5:$C$19,MATCH($G$4,$A$5:$A$19,0),) but this returns an error. I have tried modified versions of this and cannot seem to figure it out.
Thanks for this video, I learned a lot. I don't know if you can help me for a similar question or refer me to a video you already made or telling me what I should search for because I don't find answer to my question. Let's say I have movie names in column A and country in the column B. In C1 I have a drop down list yes;no, for Canada movies only. In D1 I have a drop-down list that I would like to be dependent of C1. If the user choose "No" in C1, he will have the full drop-down list of all the movies in D1. If he choose "yes", the drop-down list in D1 will be reduced to movies from Canada only. I just can't figure it out... Again, thank you for your help :)
Thanks for the video. However I have slightly different query, where I have a dropdown list and it will retrieve all the values (column in the table) from a table based on that selection. How should i do it?
Here you can use a similar technique, except you'll probably need to use name manager since you can't directly past in the data validation box. I'll actually be making a video on this in the next month or so....
That will be great too. Your videos are so much exciting. In my particular case, I i have few columns (i.e Sales person, area, product, volume) where if i choose sales person from the dropdown It will show all the sales record for that particular sales person.
Thx for your helpfull videos. Question, I'm looking for a solution where a user can select form a readable dropdownlist but when (s)he makes a choice I want to just have corresponding value (ID) in my colum. So fe ID A Automotive B Shoes C Jackets , in dropdown Automotive, Shoes and Jackets in rows that are filled A B or C. I found an option with VBA but hope it is also possible with INDEX MATCH and/or OFFSET?
Yes - you should be able to use a simple Index Match for that or even Vlookup. Have you checked out this video: ua-cam.com/video/F264FpBDX28/v-deo.html
thx for your answer but I think you didn't totally understand what I meant with my question. In a data entry form I would like user to be able to select items they can understand/search for in a dropdown but when they made a choice I just want to have an ID in my sheet because in analyzing I can do with ID's and there's no room for a wide enough colom for full descriptions. So data validation won't work I suppose but I got hope since I saw what you can do with, index, match and offset.
Is it possible to have a drop down list dependent on a MULTI SELECTION drop down list; so that the dependent list returned multiple selections corresponding to the source list selections?
Thanks so much for your tutorials. I've been following you since 5 months now and it's been quite interesting. Please, how can I go about this task? Column C7-&= contain list of expenses: e.g. Rent; as entered. Column D7-&= amount, e.g. $1200. Rows F5-L5 to contain the expenses in column C as the headings, here, "Rent" can be picked as being entered but no one must have duplicates. And each corresponding amount drops in the adjacent cells F7-& and L7-& automatically. No expenses must duplicate on F5 to L5, i.e., if already available, the amounts should drop under the corresponding existing columns or cells. Grateful for your assistance.
Hey, thanks for the video. What if you had those column names in rows next to the apps like in the previous videos and wanted to extract the unique values to a dropdown list? I did it by creating a separate list just with unique values but thought maybe there is a way without creating a new list? Also, could you make these drop-down menus to automatically update when new values are added to the table?
To automatically update, you just have to turn the data into a table. In the next video, I'll show how to get the drop-down if they are in one column instead of separate columns. Maybe that would answer your question....
hi, I apologize for the previous comment, and I have worked with me successfully, but I still have a problem, namely: whether there is another drop-down cell under "Productivity Div" For example, how can the compatibility in their work? thank you.
Is it possible to make a named range with one or more empty rows/columns in between data options and have it work as a data validation list? If I have a gap in a named range, it doesn't seem to work. The contiguous named ranges work, however.
Thanks for the video. It's really nice as usual I have two question: how to how many customers I have from table where customers names are repeated?? Second question is: how to know how many families in certain city from table contains first name, last name, and city Please give me the answers It is important
You're welcome Hevi. I have a few other videos on dependent drop down lists that work with duplicates and data in tabular format. Have a look here: ua-cam.com/play/PLmHVyfmcRKywYhC1Q9eZqR7D-_cdiwl6y.html
Question. How should i add formula in a way that it work when i filter my table rows while I make the drop downs? In other words if i want to make multiple dependent drops downs for a looking up values specifically so i add main headers, then data to look up but those also become sub headers under which there is classified data so i filter the data for the initial drop downs but those initial drop downs end up containing the data later down the line info that I don’t them to have...
Grab the file I used in the video from here 👉 pages.xelplus.com/dependent-dropdown-multiple
you are brilliant tutor for Excel make things easy to understand.
I would not express my feeling of learning such a smart thing of Excel. Appreciating your effort &
Thanks for your support for E-learning activities.
My pleasure. I'm glad the videos are helpful.
YOU ARE THE BEST EVER IN EXCEL
can not thank you enough Leila, this is the best excel description, great explanations, great timing as well!
I'm glad you liked it!
This is still a very useful feature to have on loads of workbooks I have. Thank you Leila
Another good way of your teaching style. Big salute to you.
Thank you. Glad you like the videos.
Leila you are top notch. You have done a fabulus job
Thank you! I'm glad to hear that.
in other videos they complicate it so much and u make it so easy! thanks a lot!!!
Glad to hear that, Emilia!
I searched for an answer to this issue, this video is the best
Glad to help.
Great video. I was able to solve this sub list in less than 5 mins.. Thank you
Hi Leila.. more drop-down magic. Thanks for the video and Thumbs up!
Thanks for the great tip!
Regards from Toronto, Canada
You're welcome.Toronto's great! (I studied at UofT :))
Fantastic video, wish I clicked this one first!
AMAZING Leila !!!!!!! Thank you so much for this super clear explanation.
Glad you liked it!!
Thanks for this, is there a way to select the initial array list from another tab instead?
This was very helpful. Thank you.
Always: "thumb up"
Talented people are always up there
beautiful mind , and always perfect .
Keep on doing magic .
You are an angel !
BIG Thank you from norway
You're very welcome :)
Thank you for the video! However my drop down list consist of data vary from 5 to 50 drop list, is there any way to delete the blank list from the drop down view? Just to make it look better and efficient, Thank you 😊
I have exactly the same issue, hopefully someone can help!
Same here.. still no answer?
Love the way you explained!!
Awesome mam...you just making all of us excel expert...tnx mam
You're welcome - The videos and questions from the community help me to also get better in Excel. That way everyone wins :)
Mam do have u upload videos on finacial modelling too??i need to learn financial modelling..i'd appreciate if u guide me mam
Not yet - I'm planning to do a VBA series though...
Waiting mam for vba
Hi Leila! I did a different approach to the solution on this video so I can account for dynamic rows, as well as no including empty cells in the second dropdown list. The only drawbacks for my solution is to use the EVALUATE function within a Name formula, and save the file as a macro enabled file. Other than that, these are the steps I followed:
1. Save the file as a macro enabled excel file (.xlsm)
2. Convert the range to a Table (CTRL+T)
3. Created a Name formula named TheList: =EVALUATE(CONCATENATE("OFFSET(Table1[",$K$5,"],,,COUNTA(Table1[",$K$5,"]))"))
4. Set my Data Validation for the second dynamic dropdown to =TheList
This way, the second dynamic list will only show the appropriate number of items depending on the first dropdown list (K5), without the extra blanks, and it dynamically adapt to more/less rows.
I hope my above explanation makes sense.
you can avoid evaluate
(based on Leila references)
name TheList based on formula :
=OFFSET(Sheet1!$A$4,1,MATCH(Sheet1!$G$4,Sheet1!$A$4:$C$4,0)-1,COUNTA(OFFSET(Sheet1!$A$5:$A$20,0,MATCH(Sheet1!$G$4,Sheet1!$A$4:$C$4,0)-1)),1)
Excellent piece of work to get dependent drop down list.
Thank You
Chaminda
Thanks & you're very welcome Chaminda.
great info I am using it and works great. Can this be modified to use the column info instead of rows as headers?
well explained leila i am your biggest fan
I'm glad to hear that :)
I like the way you explain thank you leila
You're welcome 😊
Thank you again Leila! This works very well for 2-level cascading drop-downs, but if you need 3-level or 4-level (continent, country, region, province, town, street - for example), then it does not work, because INDEX is not more than bi-dimensional. Any idea on how to implement a n-level drop-down controlled data input?
I'm stuck on this as well!
@@rizbfatango Try this. =IF(INDEX($A$5:$C$19,,MATCH($G$4,$A$4:$C$4,0))=0,"",=INDEX($A$5:$C$19,,MATCH($G$4,$A$4:$C$4,0)))
very nice video and done in very simple way, its very useful for me. thank Leila
You're very welcome Vishwa.
Excellent and perfectly timed to assist me in building a new (single) Project Action Register. Thank you again.!
Oh that's great! Thank you for the feedback.
You are amazing many thanks 👍
Thank you for the knowledge sharing. Just amazing🎉
GENIUS!!!! I thought I hit a wall until I saw this. Thank you so much
Glad I could help!
Wonder why didn't MS Word allow this in word forms without having to go thru bookmarks and all that mess? And I can't find where word will allow several drop downs. I have 8 columns of data with lists within lists. Ugh! You are the best teacher!
Wow! I had no idea that you could paste a formula into the list reference box. Have wondered for quite some time how to get different lists depending on the criteria selected. Definitely using it.
That's great! Thanks for your comment & support.
Your videos are so helpful and thank you very much
You're very welcome. Thank you for your support.
Many many thanks Leila good job and clear explanation
Thanks again
You're welcome Ahmed.
Hi, Really like your explanation on Formulas. I have excel in which column A is applied with list of Country Name, Column B with list of States of each country. And i want people should see respective country's state when they select country in Column A . Pls guide. Your logic work for single cell not if i apply to entire column
Very informative as usual
Very clever Leila. Thanks once again
You're very welcome Christos.
Im MS Word, I need help please😊. I made an invoice using a table for data entry. I have 2 drop down list (one is a regular drop down list), and the second drop-down is a dependent drop-down list. Both drop list contain long selections. There's no way around the long selections, it's needed. How can I get it to word wrap in the cell in the table? The margins are set for each cell. I tried alsl by selecting the table word wrap under table options. Frustrated. Thanks, Jyng
Thanks a lot Leila. God bless you.
You're very welcome Robert.
Thank you so much, this one worked.
Awesome! Thank you so much! Please keep posting such videos!! 👍👍
Thanks. Will do so :)
A great video. Well explained and just what I was looking for. Thank-you
Just what I was Looking for! Wonderful video.. Thanks a lot Leila and it's much appreciated.
Great! Glad to hear that. You're very welcome Mohamed.
I love you Leila thank you so much what i really love about you that you are explaining every step then that is so good for me to understand.
I'm very happy to hear that Ismail! You're very welcome.
Nice teaching
Thank you so much, always so great!
It helped me solve a problem of simulating radio buttons on a group of cells. I just had to find the right formula to insert in the Data Validation Form.
Let me explain in some words. I designed a group of 2 cells, one containing “x” and the other nothing (you could also use “yes” and “no”…). Let say these cells are in G4:G5.
Now let say my range of cells figuring radio buttons are in C4:C6. Then I create a Data Validation on each cell, allowing List and giving the formula =SI(NB.SI($C$4:$C$6;$G$4)=0;$G$4:$G$5;$G$5) (in French, sorry; change SI by IF and NB.SI by COUNTIF). It works great, without VBA!
I would have liked to put symbols instead of “x” and nothing. I found radio buttons in Windings but the drop-down button isn’t able to show characters in the right font. As I use mainly the Calibri font (but it’s the same in Arial for example), I use the character 0298 (Unicode) for the enabled button and character 039F for the disabled button.
And one more info; before letting the user use these radio buttons, fill all cells with the disabled button.
Nice way of using index
Thanks Douglas.
You are awesome LG
Thanks a ton ❣️
Thanks & You're very welcome Dev :)
Dear Leila, many thanks for your channel. Would be possible to sort the drop down list automatically? If there are lot of items, it could be hard to find needed data and would be perfect to have them sorted. Thanks
Hi Andrej - not yet. We'll have to do it with formulas to have it dynamic. I've added this to my list.
hi what if your list is on the other sheet? Thanks!
Thanks soooooooo much it is really helpful 🙏
Thanks for the great video : )
You're welcome Mike :)
Thnx a lot u r the best from east to the west
You're very kind! Thanks.
Hi Leila, This is useful and can be used for one dependent. But can you please post a video on how to make multiple dependent lists?
Thanks Prawin for your comment. Sure, I'll add this to my list. Multiple dependent lists would work in a very similar way as the first dependent list though.... unless your data is not structured like this....
Thanks for your response. To be precise in my request, in your above video 'Misty Wash' is dependent on 'Utility Div'. My request is, for example the next dependent should be based on 'Misty Wash' & 'Utility Div'. Like if 'Misty Wash' & 'Utility Div' is selected then 3rd dependent should show 'X' and if 'Misty Wash' & 'Twenty 20' is selected then 3rd dependent should show 'Y', etc., likewise for all.
Understood. That's a good one. Will add to my video list. Thanks for the suggestion.
Did you find a solution for the case you mentioned?, I´m looking for that solution
No. Not yet.
very helpful video ma'am.
thank u so much...😀😀😀
You're very welcome. Glad it helps :)
amazing as always, you never disappoint!
THANK YOU!!! Is there any way for the dependable cell to become blank if the first cell is changed?
This video might help: ua-cam.com/video/wWasYHG1lmM/v-deo.html
Great Job Leila, thank you, does it work in 2010 version?
You're welcome. Yes. Works on 2010 and previous versions.
Thank you for the excellent video... The 2nd case has more practical usage then the first one (in my opinion)
You're very welcome. Yes - I agree :)
Hi, can we implement multiple drop down list in MS FORMS?
@leila gharani in this lecture you said if you get zero you can use if or conditional formatting to hide that can you please explain that
Thank you Leila! It looks like this method is better than the other one requiring using INDIRECT(), because you do not need to define all those names... Right?
Thanks for the great ideas !
You're very welcome.
ur videos are awesome leila
how do you work around this if your starting drop down is already a dependent drop down
Thank you so much! This was so helpful
You're most welcome Britney! Glad the tutorial is helpful.
Thanks very helpful
Awesome, in every video, you are helping a lot to the excel users/lovers/addicts,. Once again a big, SALUTE TO your FEET.
Ohhh thank you Gopala. You are very kind! I also learn a lot from the Excel community here and I am very thankful for every one watching and providing feedback on the videos.
Hello Leila, is there any way to create a table that changes based on drop down menu selections. The value of previous table should not be there when I change drop down selections. Thanks
Do you mean like a reset? If so I have a video on that: ua-cam.com/video/wWasYHG1lmM/v-deo.html
EXCELLENT VIDEO
THANK YOU
RAJ
GHANA
You're welcome Sachin.
YOU ARE A LIFESAVER. Thank you. One more subscriber for you!
Glad it's helpful. Good to have you here :)
Hi,
Is there a way to make "ActiveCell"-dependant Drop-down list ? In your example you have Static Input cells.Its quite simple. What if we have a Table/ and one row of this table should have Drop-Down list based on the Lookup value from another table. given 1 cell from this table as an input for searching? any sugestion? VBA ?
Hi Leila! You're videos really helped a lot. I'd like to ask. In excel when does 'too many cell format' happen and what is the solution for it. Thanks and more power!
Hi @leila could I use the XLookup function in this case rather than index and match?
Hi Leila - I wonder if you can help me out. I've seen a lot of UA-cam instructions about drop down list but I don't see anything about how to create a column list. For example, I have 10 names in column A. I want to create a column list with those 10 names. Thank you for your time.
You r awesome 100%
I thank you very much for this useful illustration, you are really a genius, but I have a question: how can I add an equation so that it prevents repeating the evidence?
Thank you.
How would one write this if the Match lookup value was in column "A" and we wanted to see the values in column "B" and "C" that correspond with that lookup value. Following your example if my selection list was "A5:A19" instead of "A4:C4" and I tried to return Jellyfish and Atmos when looking up "Mirrr" what would be the equation? I tried; =Index($B$5:$C$19,MATCH($G$4,$A$5:$A$19,0),) but this returns an error. I have tried modified versions of this and cannot seem to figure it out.
Same problem here. Please help us Ms. Leila. What we will do if the data needed are across columns not rows. Thanks!
Thanks for this video, I learned a lot. I don't know if you can help me for a similar question or refer me to a video you already made or telling me what I should search for because I don't find answer to my question. Let's say I have movie names in column A and country in the column B. In C1 I have a drop down list yes;no, for Canada movies only. In D1 I have a drop-down list that I would like to be dependent of C1. If the user choose "No" in C1, he will have the full drop-down list of all the movies in D1. If he choose "yes", the drop-down list in D1 will be reduced to movies from Canada only. I just can't figure it out... Again, thank you for your help :)
Thank you Very much!
You're very welcome Esan.
Leila, you're the man :!
well you got the idea..
THANK YOUUU!
Great article
Thanks Nipun
Thanks for the video. However I have slightly different query, where I have a dropdown list and it will retrieve all the values (column in the table) from a table based on that selection. How should i do it?
Here you can use a similar technique, except you'll probably need to use name manager since you can't directly past in the data validation box. I'll actually be making a video on this in the next month or so....
That will be great too. Your videos are so much exciting. In my particular case, I i have few columns (i.e Sales person, area, product, volume) where if i choose sales person from the dropdown It will show all the sales record for that particular sales person.
Thx for your helpfull videos. Question, I'm looking for a solution where a user can select form a readable dropdownlist but when (s)he makes a choice I want to just have corresponding value (ID) in my colum. So fe ID A Automotive B Shoes C Jackets , in dropdown Automotive, Shoes and Jackets in rows that are filled A B or C.
I found an option with VBA but hope it is also possible with INDEX MATCH and/or OFFSET?
Yes - you should be able to use a simple Index Match for that or even Vlookup. Have you checked out this video: ua-cam.com/video/F264FpBDX28/v-deo.html
thx for your answer but I think you didn't totally understand what I meant with my question. In a data entry form I would like user to be able to select items they can understand/search for in a dropdown but when they made a choice I just want to have an ID in my sheet because in analyzing I can do with ID's and there's no room for a wide enough colom for full descriptions.
So data validation won't work I suppose but I got hope since I saw what you can do with, index, match and offset.
Is it possible to have a drop down list dependent on a MULTI SELECTION drop down list; so that the dependent list returned multiple selections corresponding to the source list selections?
Thanks so much for your tutorials. I've been following you since 5 months now and it's been quite interesting.
Please, how can I go about this task?
Column C7-&= contain list of expenses: e.g. Rent; as entered.
Column D7-&= amount, e.g. $1200.
Rows F5-L5 to contain the expenses in column C as the headings, here, "Rent" can be picked as being entered but no one must have duplicates.
And each corresponding amount drops in the adjacent cells F7-& and L7-& automatically.
No expenses must duplicate on F5 to L5, i.e., if already available, the amounts should drop under the corresponding existing columns or cells.
Grateful for your assistance.
Hi Leila,
Thanks a lot for the Videos,
Can you please help me in removing or recovering the forgotten password of vba code in excel.
You're welcome. Not sure about recovering the forgotten code, but I think there are tools on the net that help you do that....
Hey, thanks for the video.
What if you had those column names in rows next to the apps like in the previous videos and wanted to extract the unique values to a dropdown list? I did it by creating a separate list just with unique values but thought maybe there is a way without creating a new list? Also, could you make these drop-down menus to automatically update when new values are added to the table?
To automatically update, you just have to turn the data into a table. In the next video, I'll show how to get the drop-down if they are in one column instead of separate columns. Maybe that would answer your question....
hi,
I apologize for the previous comment, and I have worked with me successfully, but I still have a problem, namely: whether there is another drop-down cell under "Productivity Div" For example, how can the compatibility in their work?
thank you.
For multiple drop-downs please check out this detailed post from Debra: contexturesblog.com/archives/2018/06/28/multiple-dependent-drop-downs/
@@LeilaGharani thats too much complex.. any easy way ?
Hi Leila thanks for the help but when i tried it while sourcing the data from a different sheet, it is showing an error.
I have 2 columns, col 1 and 2 both have repeated items. Based on list of col 1 , col 2 items appear in the second drop down?
Thank you great
Glad you like it.
Is it possible to make a named range with one or more empty rows/columns in between data options and have it work as a data validation list? If I have a gap in a named range, it doesn't seem to work. The contiguous named ranges work, however.
Newbie question (maybe). Hoping someone can answer. How do I make this work if my list is in a separate worksheet (same workbook)?
If you just have one list, check out this video: ua-cam.com/video/FRiFfKb_B_A/v-deo.html
I do an example with the list on another sheet.
Thanks for the video. It's really nice as usual
I have two question: how to how many customers I have from table where customers names are repeated??
Second question is: how to know how many families in certain city from table contains first name, last name, and city
Please give me the answers
It is important
You're welcome Hevi. I have a few other videos on dependent drop down lists that work with duplicates and data in tabular format. Have a look here: ua-cam.com/play/PLmHVyfmcRKywYhC1Q9eZqR7D-_cdiwl6y.html
Question. How should i add formula in a way that it work when i filter my table rows while I make the drop downs? In other words if i want to make multiple dependent drops downs for a looking up values specifically so i add main headers, then data to look up but those also become sub headers under which there is classified data so i filter the data for the initial drop downs but those initial drop downs end up containing the data later down the line info that I don’t them to have...