To Get Certification, Click Here: bit.ly/38Jyu3p Use coupon "KZread12" to get ‘’FLAT 12%’’ OFF at Checkout.

The best tutor I've ever come across. Kudos to you. Always on point, no dragging, simple explanation. Thank you very much

You are an excellent teacher! You make everything so straightforward! Thank you. Feb. 6, 2021

I have learned how to make dependent dropdown list from other Excel guru, but this is the simplest and the best so far. Thank you, your tutorials are amazing.

Thanks for your simple way of explaining . One of the best excel trainer in English.

Pleasant way of teaching. Brief and clear. I have been searching for this for quite sometime finally found a good teacher. 👍🏼

You r genius l know named ranges for past 20 years but don't know shortcut of creating multiple names at a time and also use of indirect function thank u very much hats off you 🙏🙏🙏

I read a million blogs and it shows the weirdest ways to build out this mechanism, this was sooo simple

"The Source currently evaluate to an error" this is the message I got when I try to use the "INDIRECT" Function for the drop down. However one of the drop down returns for me but the other does not

simple ...to the point ....value for your time and need ....no cliche....👍👍

Incredible tutor, brilliant explanation - very precise and clear. Thanks a lot.

Sir, I was more than one-hour spending my time segregating data but using this formula short out the data minimum time. thank you so much

Went thru many videos to get this done conveniently. Everyone was using complex combinations for this. But this was so simple. Thank you. Subscribed.✅

Great Teaching, in short time, clear, precise n up to the mark!..

This is brilliant. You have explained every step and why you've done it, rather than just say do this then this. I've spent ages trying to do this today, your video helped in a matter of minutes.

@real1083

2 жыл бұрын

Excellent work

What a great teacher. I was looking for this formula for more than 3 weeks. Finally I got exactly what I wanted for. Thanks alot.

@BhupendraKumar-mh3lg

2 жыл бұрын

Sir can you explain me again. I am unable to apply this.

Wonderful thank you so much I was broken my head fr this one for such a long time finally I got to know how to do that with ur video.👍👍

Thanks for making it simple and Precise. I appreciate you 👍🏼

Sir You are an Ultra Amazing Technics about how to teach people in terms of any kind of mind, you can do very smoothly, Thanks a lot from my bottom of heart. God Bless You, Stay Healthy & Stay Safe.

Thanks a ton... thank you very much.....was just looking for this indirect function....you have made things just very simple.

Excellent video without any nonsense...Thanks !

you people have all the tutorials i ever need for excel great videos

Love you tutorial point....I prefer your video instead of others

Super video sir.. no one can teach with this simple with indepth details.. thanks a lot

Thanks a lot for this video ...... I have been looking for this kind of smart option to enhance our work... The way you teach is very good and easy to understand... Keep doing ......

Here is another indian hero saving the world. Thank you so much

Awesome your all the video on Excel are excellent and I have never come through to such a easy way of teaching I don't know anything about Excel and I'm able to understand and learn it from hear your videos great job sir

wow best teaching style i have ever seen...thank u sir

Best and shortest explanation. Brilliant and Big Thanks

I have followed as you showed and it works..

Great, Thanks for teaching, Its really helped a lot.

As usual Short & Sweet.!🤗

This is the best way I have seen about this topic... Thank you!

Sir aap jo b pdhate ho sbkuch achhe se clear ho jata h

perfect sir, amazing and very easy steps with cool accent .. thanks and good wishes

Thank you so much. my doubts are cleared now.

This is such a big help! Thank you Sir! :)

He is an excellent teacher for Ms. Excel.

Thanks for your nice & easy tutorial on conditional dropdown list.

Excellent example and speech. Thank you

Bro, You are a great teacher. Lot of love

Very nice and clear to the Points. Well simplified and nice presentations. Keep it up !! Good Luck !.

U da Besssssttttt ı have been looking for this all-day! Thank you thank you thank you!

@ifeanyiadika6871

3 жыл бұрын

This still hasn't worked for me, after using indirect function inside the data validation source, the cell does not open up as it should. Any help?

@Whiskey_ki_Mummy

3 жыл бұрын

@@ifeanyiadika6871 same here.. didn't helped me out..

Your Tutorials are awesome and crafted carefully for the audience to learn the steps perfectly and thoroughly. I am wondering how to apply this formula for multiple criteria's. Example, I want to have "List of Tasks: as dynamic dropdown when "Project Code" and "Category" is selected, and it should be on Every Row. @TutorialsPoint_ do we have any tutorial for similar scenario which I mentioned above.

Your learning methods are ousam. I like it 👍 Keep it I learn from you all

Nice... I hope u will teach us in a very simple language as usual. Thanks a lot..

Excellent and very easily understood, thank you very much

You're a legend. Thank you!

Thankyou somuch,So Informative,Love from Saudi Arabia.

This guys explanations are so smooth

While creating the name range for the columns with different number of values in each column you could face with an error. The workaround is to select the columns one by one and name them based on the top row. this is the solution.

@nanakay4078

2 жыл бұрын

I had a similar issue until I tried your solution. It worked! Thanks mate! ✌

@sohailshaikh8670

Жыл бұрын

Not understood please can you explain

@jabdullayev7617

Жыл бұрын

@@sohailshaikh8670 To be honest I myself even did not understand what I tried to mean 2 years ago :D Tell me what is your problem may be I can help )) Actually everything works perfectly fine when while doing everything according to instructions in video.

This channel is gold.

Easy to understand, good teacher 👍👍👍

Keep doing what you doing!.

Good work brother. Very well explained. Thank you very much

thanks a lot for sharing this. You were really great to put this in such a short span of time.

Best explanation ever i seen...

very much useful & so easy demonstration!!

simple way you have given us. thanks

Thanks you so much I learnt new thing today with this.

Hi Friend you doing a good job. good simple easy clarity in your videos. very good. Here is my question how can I add alphanumeric in dependant drop down list in a simpler way?

Its excellent thank you for sharing knowledge

Hello sir...when i am trying to apply the second step it's throwing an error. Please advise

This is FANTASTIC!

Excellent way of presentation. Weldon bro. Keep it up 🙂

you are a gem sir. thanks a ton.

Extremely helpful - thank you!

thank you!!!! this was made so simple!!!! love it

Sir ,you are the best teacher .. But sir please make a 1 video on shortcut keys

This is exactly what i needed.. beautifully explained . Thanks. Sir, how to delete the header names that we provide by "Create from Selection" . I wanted to change header name however it also show the old ones ,so want to remove it from the top left hand corner section (Name Box i htink)

Thanks for the beautiful explanation

Very much helpful really liked it. 👍

Thanks! Learnt Drop down today.

Very useful informations, thanks for sharing such a beautiful video

Great tip. I was looking for it.

Thank you. Nice and very helpful tutorial

Very nicely explained. 👍👍👍 Hope this will help me in my work.

Very nice , helpful & well explained video

Very Short & Excellent...... 👍

Thank you. Can you guide what should be done to keep dependent value to go blank once I deselect the countries option

hello sir INDIRECT FUNCTION IS SEEMS TO VERY IMPORTANT FOR LARGE DATAS , thnk u sir

Thanks a lot... It's short and clear

Thanks a lot , you saved my time !

Thanks alot... This really worked for me....

really helpful, many thanks.

Thank you so much for this great help

Really thank you so much... I have tried many ways to do this finally got to know... thanks learned new thing.

love your tutorial.thumbs up

Good teaching, I like this.

Great video. Although I am curious as to whether this can be done across a vertical list? Thanks 😊

@r.c.t.privatetuitionrct5209

Жыл бұрын

same question ....have you found about this solution?

Thank you.. the video was very helpful..

You have made it look so easy thank you

That was so simple. Thank you

Easy way to understand , helped me lot

Excellent sir... Thank you so much

Thank you so much for this video...

Great! But I Would Like to know how to create unique dropdown list from duplicate names and total of corresponding data

Sir, Nice explanation easy to understand Thanks Sir

To add more data to the list so that the list expands is there a special formula? Great video! Thank you

You can use a combination of indirect & substitute functions if you want to include table names with spaces in them.

@staysweden

Жыл бұрын

How? Can you explain. My list has space, so this method is not working