We have additional free Microsoft Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & How to Create a Dashboard in Excel here 👉ua-cam.com/play/PLzj7TwUeMQ3g1WJPlf-mojgdR3gN-JWIz.html 🔥Check out our FREE 300+ hour training course playlist here ➡ ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you so much for your kind words! I'm glad to hear that my videos have been helpful to you. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
I'm so glad you found the method helpful! It can be frustrating when you're searching for a solution for a specific dropdown. Keep up the great work! 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
@Simon Sez IT What would be a way to avoid the preparation tables and directly incorporate all actions in the Data Validation source field? I tried a few things but failed when the formula involved FILTER.
Only thing I think this could have used it showing how to use a filter that could do AND or OR as well to define conditionals, for instance showing everyone with salaries above a certain range. But this was a great start to creating my filtered lists and has helped me, thank you!
You are very welcome! Glad it was helpful. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Very Useful, I only Changed the Function Vlookup to INDEX Combined With MATCH, because the Vlookup function needs to have the data in the first Column to work properly.
This was great. I finally got it to work. For some reason having all this on different worksheets caused me some issues. I finally moved my preparation area to where the data was going to displayed but when choosing the columns that are on another worksheet the worksheet names would revert to where I was displaying the data and not where the data was stored. I manually edited them and viola it worked. I am wondering why I shouldnt enter the entire formula into the Data Validation Source without having to have a prep area. Guess I will find out. The biggest pain for me is I should have prepped my data, such as sorting alphabetically before creating the table. That was a pain but a lesson learned. Now that i have it working with the exception when my first drop down changes to another team, the people in the next drop down stays until I show the drop list to change it. I wonder if there is a way for it to show blank when I change the first drop down? Just someone wanting to learn more advanced Excel stuff and thanks in advance
Thanks for watching. We're glad you enjoyed the video! 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Hi , this video is very helpful , i did it but my question is , i want to drag it down but the inputs or drop down list shows wrong when you try to do it to the next cell
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Great video instructions, I have a slightly more complicated version of this and wondered if it is possible to create a 3rd validation dropdown using a delimited list of Approvers (without having to manually type the delimited list as they are in one column in my table separated by a comma) which is based on values in other fields and if in the vlookup formula you can concatenate two fields. My approver list is not unique as the list of approvers are based on the (entity) + (office ID & office location)(concatenated) and a single approver can be part of the list of approvers for multiple offices. Do you have a forum I can email example to?
This was incredible, what if you had job titles that were the same for different departments? Is there a way to filter on two columns, so the third is filtered by Department and Job Title?
Wonderful video! How do I copy and paste the drop down lists into multiple rows? When i do a normal copy and paste, the drop down lists go out of sync because it is based upon the cells selected for the first row and subsequent drop downs. Is there a way to do it quickly without having to manually change the cell references and having to create new drop downs for each row?
Good Explanation. Thank you. I found that Excel can be broken into two or more views. IF you did that then you could put the info (preparation data) on a second sheet and show both at the same time further enhancing a student's ability to take your tutorial information and apply it in their real world. QUESTION: What about when you are inserting a Dependent Drop-Down List into an existing Table? Unfortunately, your destination wasn't a Table (1 row per Job Invoice) whereas your data source was a Table, which was fine. But my real world Table of Client orders [3 Columns: 1) Client drop-down, 2) Type drop-down, 3) VLOOKUP dollar value], fails on the second column even though -F9 picks the correct list items. "=TRANSPOSE(OFFSET(Tbl_BCC[[#Headers],[BCC]],1,MATCH([@[Council (Road)]],List_Councils,0)-1,COUNTA(OFFSET(Tbl_BCC[[#Headers],[BCC]],1,MATCH([@[Council (Road)]],List_Councils,0)-1,6)),))" I get a #SPILL! error that doesn't go away, with or without Transpose. Nice solution for the last Part - picking single choices (quantities) - V/H/XLOOKUP automagically inserts the matching value.
When I input a hash for the data validation list, the following message comes up "The Source currently evaluates to an error. Do you want to continue?" Please may someone explain why, thanks!
There is Highly likely that two persons have same name, but if we could VLOOKUP using concatenation there would be chances of getting the particular salary.
Can you try to record with a minimum respect towards what you are trying to share with us ? Like , for example show the cursor when it's moving , that way we can follow step by step....Anyways..who am I to say something else rather than fuckin thanks .
We have additional free Microsoft Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & How to Create a Dashboard in Excel here 👉ua-cam.com/play/PLzj7TwUeMQ3g1WJPlf-mojgdR3gN-JWIz.html
🔥Check out our FREE 300+ hour training course playlist here ➡
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you so much
I have been searching and searching . no one has given me the answer i was looking for except you .
Thanks 🙏
Wow, thanks! Glad it was helpful. 🤩
This explains all about I am looking for! Unique, Filter, and Multiple dependent drop down lists. Thank you so much for this great tutorial!
Glad it was helpful!
Really helpful. I have learnt a lot from your videos . Much love from Kenya
Thank you so much for your kind words! I'm glad to hear that my videos have been helpful to you. 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
My god, FINALLY!!!! Thank you Deb! You have no idea how long it has taken to find a method that works for that 3rd dropdown!!!
I'm so glad you found the method helpful! It can be frustrating when you're searching for a solution for a specific dropdown. Keep up the great work!
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
@@SimonSezIT You just earned a sub!
Great video from a great teacher! The little tip with the ,,#" has solved my entire Workbook! Thank you so much!
Great to hear!
Nice tutorial, wonderful, helpful, saved my life!!!
Glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
@Simon Sez IT What would be a way to avoid the preparation tables and directly incorporate all actions in the Data Validation source field? I tried a few things but failed when the formula involved FILTER.
Only thing I think this could have used it showing how to use a filter that could do AND or OR as well to define conditionals, for instance showing everyone with salaries above a certain range. But this was a great start to creating my filtered lists and has helped me, thank you!
This is a great alternative to using name ranges to create dependent dropdown list.
It is indeed!
Really helpful! thanks for this great video.
You are very welcome! Glad it was helpful. 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you ! You are providing us great tutorials .
Delighted you’re enjoying them Ameha!
Today I have solved my data multiple dependent drop-down lists depending on other links. Thank you so much for your nice video.
Today is a good day! Well done
very good and informative video . thanks
further please make a video for multiple searchable drop down list. thanks
Very Useful, I only Changed the Function Vlookup to INDEX Combined With MATCH, because the Vlookup function needs to have the data in the first Column to work properly.
Thank you.. thank you.. thank you.... so much!!!!!.. this is what i really looking for.. (and I immediately subscribed).. thank you so much again....
This was great. I finally got it to work. For some reason having all this on different worksheets caused me some issues. I finally moved my preparation area to where the data was going to displayed but when choosing the columns that are on another worksheet the worksheet names would revert to where I was displaying the data and not where the data was stored. I manually edited them and viola it worked. I am wondering why I shouldnt enter the entire formula into the Data Validation Source without having to have a prep area. Guess I will find out. The biggest pain for me is I should have prepped my data, such as sorting alphabetically before creating the table. That was a pain but a lesson learned. Now that i have it working with the exception when my first drop down changes to another team, the people in the next drop down stays until I show the drop list to change it. I wonder if there is a way for it to show blank when I change the first drop down? Just someone wanting to learn more advanced Excel stuff and thanks in advance
Great instructional video!
I do still wonder, though, how to make mutually dependant list. Can you help?
Very nicely explained.
Thank you! 🙂
Very Nice!
Thanks for watching. We're glad you enjoyed the video! 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Hi, it is one of the best explained and thank you for explaining at its best, how can we make the drop down in every row.
Hi did you ever figure this out, I am working on the same thing
Very nice. Thanks
Most welcome
Hi , this video is very helpful , i did it but my question is , i want to drag it down but the inputs or drop down list shows wrong when you try to do it to the next cell
thank you very much 😁
Glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Can you not do the exact same with the already build in filters in row 1? How is this easier/better?
Great video instructions, I have a slightly more complicated version of this and wondered if it is possible to create a 3rd validation dropdown using a delimited list of Approvers (without having to manually type the delimited list as they are in one column in my table separated by a comma) which is based on values in other fields and if in the vlookup formula you can concatenate two fields. My approver list is not unique as the list of approvers are based on the (entity) + (office ID & office location)(concatenated) and a single approver can be part of the list of approvers for multiple offices. Do you have a forum I can email example to?
This was incredible, what if you had job titles that were the same for different departments? Is there a way to filter on two columns, so the third is filtered by Department and Job Title?
You can use asterisk to signify AND when selecting your include, just surround it by parentheses
Wonderful video! How do I copy and paste the drop down lists into multiple rows? When i do a normal copy and paste, the drop down lists go out of sync because it is based upon the cells selected for the first row and subsequent drop downs. Is there a way to do it quickly without having to manually change the cell references and having to create new drop downs for each row?
Did you found the answer? Having the exact same problem 😢
@@cristinasilverio5635 same here, did you find the answer?
Hi, how to make default option for all 3 list options after some select? Meaning restart for all 3 option to blank?
thanks
Good Explanation. Thank you.
I found that Excel can be broken into two or more views. IF you did that then you could put the info (preparation data) on a second sheet and show both at the same time further enhancing a student's ability to take your tutorial information and apply it in their real world.
QUESTION: What about when you are inserting a Dependent Drop-Down List into an existing Table? Unfortunately, your destination wasn't a Table (1 row per Job Invoice) whereas your data source was a Table, which was fine. But my real world Table of Client orders [3 Columns: 1) Client drop-down, 2) Type drop-down, 3) VLOOKUP dollar value], fails on the second column even though -F9 picks the correct list items.
"=TRANSPOSE(OFFSET(Tbl_BCC[[#Headers],[BCC]],1,MATCH([@[Council (Road)]],List_Councils,0)-1,COUNTA(OFFSET(Tbl_BCC[[#Headers],[BCC]],1,MATCH([@[Council (Road)]],List_Councils,0)-1,6)),))" I get a #SPILL! error that doesn't go away, with or without Transpose.
Nice solution for the last Part - picking single choices (quantities) - V/H/XLOOKUP automagically inserts the matching value.
When I input a hash for the data validation list, the following message comes up "The Source currently evaluates to an error. Do you want to continue?" Please may someone explain why, thanks!
I followed the tutorial but kept getting #CALC! Notice. Any tips on how to fix that?
when using unique and filter, what if the data has a blank and you want to not have a 0 as a result?
Best way I found to do this is to make sure you have a blank cell in one of the categories in your table, unfortunately
Take my energy
What do you suggest doing if your version of Excel does not have the UNIQUE function?
There is Highly likely that two persons have same name, but if we could VLOOKUP using concatenation there would be chances of getting the particular salary.
I wonder why FILTER is an INVALID FUNCTION on my end... :(
Can you try to record with a minimum respect towards what you are trying to share with us ? Like , for example show the cursor when it's moving , that way we can follow step by step....Anyways..who am I to say something else rather than fuckin thanks .
Appreciate your feedback. Thanks for watching! 😃