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.

I have often use indirect, this is a really powerful function. Nice content !

INDIRECT: Awesome, I've needed that function so many times!

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.

the best video to show the easiest way to set Downlist as so far, no need any edit any sourcecode.

Love your videos, they have helped me figured out so much! Thank you!

This is great! Very detailed explanation of the concept. Thank you :)

@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

Wish I found this back in 2017! Thanks for putting it together!

Thank you very much. I got what I expected. Keep posting

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

Ages later, this is still helpful! ty needed something like this.

Thank you very much for the tutorial. Very helpful!

Thank you! This was so helpful!

You are a good teacher, thanks

Amazing tutorial, very detailed as usual, thank you !

Thank you so much this video helped a ton!!

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!

Thank you so much!! Great tutorial!!!

This is one of the coolest things I know in Excel.

You helped me a lot !!! Thank you

Good training! Thank you!

That is crazy useful - thank you!

That's really an awesome tutorial, brother. Thanks a lot for sharing this with us.

Thank you! This was so helpful

Awesome. This video helps me. Thank you!

Thank you so much. This video helped me change the names everywhere but it worked. Thanks.

Thank you for the tutorial.

Great explanation!!!!!!!!

this is the most useful youtube channel ever

This is actually clever! Love it

Muito bom. Você acaba de ajudar um Brasileiro :) thank you

Great job I like your way to do that AWESOME

Thanks matey. Really helps

Works perfect for row 2, but what if I need data validation for multiple rows?

@Lola.Owlace

3 жыл бұрын

kzread.info/dash/bejne/pWF9mrxtnreqkc4.html

@extremegaming8718

Жыл бұрын

Is this answered

Impressive. The tutorial is very easy to understand. Thank you.

Bless your soul. This is pure genius.

Great video...very easy to follow!

It's genious! Thank you a lot!

Great presentation skills and teaching habits

Fantastic! Thank you so much!

Now I can sleep! 😂 Very well taught. Thank you!

Harikasın. Süper!!! Thank you very very much. I like this

thank you very much, this is answering my question

OMG this is what i need!! Thank you sm !!

thank you very much, very easy to understand, you are a very good teacher. many thanks

Thanks. That was useful

Thanks for the video.

Amazing!! Just what i was looking for. Thanks for sharing!

@ExcelGoogleSheets

2 жыл бұрын

Great to hear!

Thank you so much!

Great! Many thanks!

Unbelievably helpful

Very useful, 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?

Awesome, Thank you so much for sharing this. So much appreciated!

Well done! Thanks a lot.

VERY HELPFUL! THANKS A LOT

Thanks a lot sir!

super good explained! thnks :)

Great video, thanks

Just what i was looking for straight to the point, would give two thumbs up if i could thanks

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.

I love you this is the best one

A big 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.

Can this be done using a FILTER function? So that its more dynamic & doesnt need named ranges?

Try this with FILTER function, when you understand how to do it you'll absolutely love it)) Thanks for the video

Great! Thank you very much!!

Thanks bro !!!!

Fantastic!

This is so amazing! Thank you for sharing!!!!

@ExcelGoogleSheets

2 жыл бұрын

Glad you enjoyed it!

@thaocao3563

2 жыл бұрын

@@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?

That's awesome! 😱

Amazing!!!

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?

@dzilen

4 жыл бұрын

I guess the author does not know how!!! without this function his advice is not very helpful

Wonderful. Is it possible to extend to more than two independent drop down lists?

Wow! Thank you

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?

@ExcelGoogleSheets

6 жыл бұрын

kzread.info/dash/bejne/Y4d9sJeHqbSflto.html

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 :)

thanks a lot!!!!!!, know... how do I do the same fo multiple rows in the " main " tab?

Excelente - Gracias.

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!

Now make second similar row

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

Excellent, echoing Mr. Parsons, you have that knack for speaking off the cuff with very few errors. Could you bottle that ? You could retire! I had no inkling that I could make a validation range from a ROW, I've always assumed COL only. Video would have been worth it just for that

Thanks!!

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?

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 very much!

Good video, well presented, thanks! How can I change 3 dropdown lists simultaneously, based on 1 dropdown?

wonder if you know for multiple dropdown list

Nice content! thanks! And if in tab "main" you have other rows with dropdown lists? It's way more common to have this scenario than just have one row with it. The way it is if you copy the validation date cells and you choose another option it won't work because you have already an information "filtered" in the "lists" tab.

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?

@MicroAnalytics

2 жыл бұрын

Not exactly get your query. But you may try textjoin function with Arrayformula

thank you so much.

Great video, please let me know the solution to my problem related to this technique. I am using your script for the same purpose you mentioned. I just need to use this script in all sheets of a spreadsheet and not only on whats named "Main" which means I don't want to give it a particular sheet's name to run this script on. Also I don't want the script to draw the lists from only sheet which is named "lists" and I want it to search in the same sheet where its running the script on. The places from where to look for data I can set, I just need help with the above 2. Thanks dude.

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

2 жыл бұрын

?

@smaccsi

Жыл бұрын

@@Sankofa906 what do you not get ? he just wants to have more dynamic dropdowns beneath the first one

Thank youuuu

thank you