Amazing tutorial thank you. Just took a workload off one's shoulder with these nifty tips. I especially liked the "define named range". While struggling to get a function to work, it's really tedious having to mark up the ranges again and again.
@7:40 MY MAN! Thinking ahead and creating solutions for upscaleability (if there is such a word). Great tutorial and I am VERY grateful for it. Thank you
In excel we can do it easily, if I have a column full of drop down how to do it ? In excel we enter it (Indirect formula) directly in data validation bar, how to do the same in google docs?
Works great for one row. But what if you have a list of people, say karate students, each with a pull-down for rank (beg, int, adv, black) and a contingent weight division indirectly linked to rank (light, light-middle, middle, middle-heavy, heavy). Do I have to construct this for every student? I tried using the indirect function in the data validation window and I get an error.
is it possible to eliminate an option from a dropdown after it is selected, I have several drop down lists, and I want to make sure I can't select the same item multiple times from a single list.
Hey great video! I have a question, I'm trying to do a drop-dpwn menu with dates. I want it to show Month-Year (MMM-YY) I put the format in in the list of months-years but when I set the drop down, it will show the list as "dd/mm/yyy". Can I change that somehow? The format of the date IN the drop down? Thnx!
So if you want to add another colummn for new brand do you have to define new range for that brand. Is it any way to deffine range automaticly or to use indirect function without deffining range. If so how to make it?
This was so helpful thank you! Could you direct me to a way to duplicate the function of the cells drop-down lists to multiple cells? or do they need to be done individual rows as show above?
@@ExcelGoogleSheets If I want to create a series of such dependent dropdown lists like this, how can I do it? I can not drag it like usual right? What should I do? Can you show me how?
After you select the model, would you be able to populate some cells to the right to display packages available, without them being in a drop-down? So after you choose Toyota and Corolla, could you (to the right) display: [L] [LE] [SE] etc? Brackets denote a separate cell.
How can you make it work for a long list of rows?? When I set up another row under Toyota, the main drop down does not auto-populate to the next dependent submenu.
Fantastic, I’d really like to take it a step further and have another column that was colour. But the name range seem to conflict. Can you advise on this please
im wanting to do something similar but i want to use data from 3 seperate drop down menus to get the final drop down menu (eg, car make, model to get the data of what extras tyou can get for that particular model) is there any way to do it on google sheets?
Wow. This is very helpful. Very much what I was looking for. However, how do I go about replicating that row down till the last row? Considering that my data is a different or very row has a different manufacturer and make? Will all the formula in this tutorial hold good even then? When replicated!? A response would be greatly appreciated :)
WONDERFUL CHANNEL! i wish i saw this earlier. do you have a video explain in short the differenct formulas? (example IF is.... SUMIF is.... IMPORT ..LINKING... QUERY ) trying to go thru all your videos to see what is relevant for my work needs. thank you again for teaching !
Very nice tutorials! I've learned so much from you! But I have a question if you don't mind: If you continue down the A column with brands, how can you make the dropdown in B column continue down as well and be dynamic as it is in the video? I mean, lets say A3 is BMW, A4 is Audi, etc. how can the B3, B4 update as well and all this to continue down the columns? Thanks!
Thanks, this really useful. I have another issue though, could you please suggest a way around? I have a cell which can have possible set of values (like a dropdown option) but this cell could have multiple values among the options. It can separate the values by a comma, or other delimiter. Is there a way user can select multiple values in a cell?
This is great, but can I do the options with multiple sheets? Like if cells B2 is "Alfa" > C2 will gave filtered list on sheets called "Alfa" and so on,
How can I arrange data like this where my col1 is category and col2 is color. How can I sort this two column dynamically like yours. Where row will be col1 and col will sorted based on col1
Hi there, very helpful video. Is there anyway you can do the indirect function for multiple cells simultaneously or you can do it only one by one? thanks anyway
Can you explain pick the subject line depending on open rate. What I need some of them send min no of email send, then find the open rate is maximum for eg. 50 email send, opens 25 it's open rate was 50 %, at the same some other send 100 emails, open 25 and open rate only 25% at this point how can I pick subject line depending upon openrate. Here no target of email send fixed. Plz reply
what you in Main you have multiple entries of Make. e.g. A2- Toyota, A3-Mercedece , then in lists sheet do i need to duplicate that dynamic generated values. i wanted to create an expense tracker with expense category and subcategory. although on google sheet not able to use INDIRECT function in the datavalidation LIST, it works on MS excel. e.g. in data validation list range =INDIRECT(D2)
Perfect, no music, clear speaking and intelligent! Click here to send him a new BMW
Great tip about leaving room in your range to add items in the future since blanks won't be included in the drop down.
Amazing tutorial thank you. Just took a workload off one's shoulder with these nifty tips. I especially liked the "define named range". While struggling to get a function to work, it's really tedious having to mark up the ranges again and again.
INDIRECT: Awesome, I've needed that function so many times!
I have often use indirect, this is a really powerful function. Nice content !
the best video to show the easiest way to set Downlist as so far, no need any edit any sourcecode.
Excellent presentation. Did a lot of pausing and rewinding. But, finally mastered the concept. Works perfect!
It can get quite complex, but it's very useful, and your tutorial was great. Thank you.
Wish I found this back in 2017! Thanks for putting it together!
@7:40 MY MAN! Thinking ahead and creating solutions for upscaleability (if there is such a word). Great tutorial and I am VERY grateful for it. Thank you
Love your videos, they have helped me figured out so much! Thank you!
Thank you very much. I got what I expected. Keep posting
Ages later, this is still helpful! ty needed something like this.
This is great! Very detailed explanation of the concept. Thank you :)
Many Thx for the knowledge man u deserve more views and sub.. sadly alot of ppl love to watch compilation tiktok videos. Keep doing this man
Thank you! This was so helpful!
Thank you very much for the tutorial. Very helpful!
Amazing tutorial, very detailed as usual, thank you !
In excel we can do it easily, if I have a column full of drop down how to do it ? In excel we enter it (Indirect formula) directly in data validation bar, how to do the same in google docs?
This is one of the coolest things I know in Excel.
You are a good teacher, thanks
That is crazy useful - thank you!
Thank you! I've seen it done is with array formula function, but this seems to be more readable. Not as intuitive as Excel, but awesome either way!
this is the most useful youtube channel ever
Thank you so much this video helped a ton!!
That's really an awesome tutorial, brother. Thanks a lot for sharing this with us.
Bless your soul. This is pure genius.
Great presentation skills and teaching habits
Awesome. This video helps me. Thank you!
Works great for one row. But what if you have a list of people, say karate students, each with a pull-down for rank (beg, int, adv, black) and a contingent weight division indirectly linked to rank (light, light-middle, middle, middle-heavy, heavy). Do I have to construct this for every student? I tried using the indirect function in the data validation window and I get an error.
Thank you so much. This video helped me change the names everywhere but it worked. Thanks.
This is actually clever! Love it
Great job I like your way to do that AWESOME
Thank you so much!! Great tutorial!!!
Good training! Thank you!
Impressive. The tutorial is very easy to understand. Thank you.
Now I can sleep! 😂 Very well taught. Thank you!
You helped me a lot !!! Thank you
Can this be done using a FILTER function? So that its more dynamic & doesnt need named ranges?
Unbelievably helpful
Muito bom.
Você acaba de ajudar um Brasileiro :) thank you
Thank you! This was so helpful
is it possible to eliminate an option from a dropdown after it is selected, I have several drop down lists, and I want to make sure I can't select the same item multiple times from a single list.
Works perfect for row 2, but what if I need data validation for multiple rows?
czcams.com/video/s-I8Z4nTDak/video.html
Is this answered
Great video...very easy to follow!
thank you very much, very easy to understand, you are a very good teacher. many thanks
Thank you for the tutorial.
Amazing!! Just what i was looking for. Thanks for sharing!
Great to hear!
OMG this is what i need!! Thank you sm
!!
thank you very much, this is answering my question
Try this with FILTER function, when you understand how to do it you'll absolutely love it)) Thanks for the video
Amazing! Thank you so much!
Just what i was looking for straight to the point, would give two thumbs up if i could thanks
Thanks matey. Really helps
Great explanation!!!!!!!!
Is it possible to continue this validation down the column? So that if A3 is Audi, B3 will also only show the option available for Audi?
czcams.com/video/1SIN5NyQ9fw/video.html
Very useful, thank you!
Awesome, Thank you so much for sharing this. So much appreciated!
super good explained! thnks :)
Great! Thank you very much!!
Well done! Thanks a lot.
Hey great video! I have a question, I'm trying to do a drop-dpwn menu with dates. I want it to show Month-Year (MMM-YY) I put the format in in the list of months-years but when I set the drop down, it will show the list as "dd/mm/yyy". Can I change that somehow? The format of the date IN the drop down? Thnx!
Thanks for the video.
So if you want to add another colummn for new brand do you have to define new range for that brand. Is it any way to deffine range automaticly or to use indirect function without deffining range. If so how to make it?
This was so helpful thank you! Could you direct me to a way to duplicate the function of the cells drop-down lists to multiple cells? or do they need to be done individual rows as show above?
I guess the author does not know how!!! without this function his advice is not very helpful
This is so amazing! Thank you for sharing!!!!
Glad you enjoyed it!
@@ExcelGoogleSheets If I want to create a series of such dependent dropdown lists like this, how can I do it? I can not drag it like usual right? What should I do? Can you show me how?
It's genious! Thank you a lot!
After you select the model, would you be able to populate some cells to the right to display packages available, without them being in a drop-down? So after you choose Toyota and Corolla, could you (to the right) display: [L] [LE] [SE] etc? Brackets denote a separate cell.
Wonderful. Is it possible to extend to more than two independent drop down lists?
thanks a lot!!!!!!, know... how do I do the same fo multiple rows in the " main " tab?
Great video, thanks
Thanks. That was useful
Harikasın. Süper!!! Thank you very very much.
I like this
VERY HELPFUL! THANKS A LOT
Now make second similar row
How can you make it work for a long list of rows?? When I set up another row under Toyota, the main drop down does not auto-populate to the next dependent submenu.
Fantastic, I’d really like to take it a step further and have another column that was colour. But the name range seem to conflict. Can you advise on this please
A big thank you!
Thank you so much!
im wanting to do something similar but i want to use data from 3 seperate drop down menus to get the final drop down menu (eg, car make, model to get the data of what extras tyou can get for that particular model) is there any way to do it on google sheets?
Great! Many thanks!
Can the data validation extend to more rows? Row 3, column B is pulling from what I input in row 2 column A.
same question here, hope to get an answer.
@@aimeo.saladaga2505 check link below, maybe it will help
I follow your instructions to the T but I get an error message when I try. I dont know why.
Thanks a lot sir!
Wow. This is very helpful. Very much what I was looking for.
However, how do I go about replicating that row down till the last row? Considering that my data is a different or very row has a different manufacturer and make? Will all the formula in this tutorial hold good even then? When replicated!?
A response would be greatly appreciated
:)
That's awesome! 😱
Fantastic!
WONDERFUL CHANNEL! i wish i saw this earlier. do you have a video explain in short the differenct formulas? (example IF is.... SUMIF is.... IMPORT ..LINKING... QUERY ) trying to go thru all your videos to see what is relevant for my work needs. thank you again for teaching !
thank you so much.
Very nice tutorials! I've learned so much from you! But I have a question if you don't mind: If you continue down the A column with brands, how can you make the dropdown in B column continue down as well and be dynamic as it is in the video? I mean, lets say A3 is BMW, A4 is Audi, etc. how can the B3, B4 update as well and all this to continue down the columns? Thanks!
?
@@Sankofa906 what do you not get ? he just wants to have more dynamic dropdowns beneath the first one
Thanks, this really useful.
I have another issue though, could you please suggest a way around?
I have a cell which can have possible set of values (like a dropdown option) but this cell could have multiple values among the options. It can separate the values by a comma, or other delimiter. Is there a way user can select multiple values in a cell?
Not exactly get your query. But you may try textjoin function with Arrayformula
Excelente - Gracias.
This is great, but can I do the options with multiple sheets? Like if cells B2 is "Alfa" > C2 will gave filtered list on sheets called "Alfa" and so on,
Amazing!!!
How can I arrange data like this where my col1 is category and col2 is color. How can I sort this two column dynamically like yours. Where row will be col1 and col will sorted based on col1
Hi there, very helpful video. Is there anyway you can do the indirect function for multiple cells simultaneously or you can do it only one by one? thanks anyway
And what can we do for multiple rows with same drop down button like for countery and then district
Can you explain pick the subject line depending on open rate. What I need some of them send min no of email send, then find the open rate is maximum for eg. 50 email send, opens 25 it's open rate was 50 %, at the same some other send 100 emails, open 25 and open rate only 25% at this point how can I pick subject line depending upon openrate. Here no target of email send fixed. Plz reply
I am trying to add a column for my vinyl color selection. I want the ability to choose color and quantity.
what you in Main you have multiple entries of Make. e.g. A2- Toyota, A3-Mercedece , then in lists sheet do i need to duplicate that dynamic generated values. i wanted to create an expense tracker with expense category and subcategory. although on google sheet not able to use INDIRECT function in the datavalidation LIST, it works on MS excel. e.g. in data validation list range =INDIRECT(D2)