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 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.
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.
"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
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
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.
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.
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.
@@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.
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?
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 ......
Hi. The INDIRECT thing is not working in the data validation for me. The error shown is “The source currently evaluated to an error” Can you please help
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "UA-cam12" 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 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
You are an excellent teacher! You make everything so straightforward! Thank you. Feb. 6, 2021
you people have all the tutorials i ever need for excel great videos
simple ...to the point ....value for your time and need ....no cliche....👍👍
Incredible tutor, brilliant explanation - very precise and clear. Thanks a lot.
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.
Sir can you explain me again. I am unable to apply this.
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.
Excellent video without any nonsense...Thanks !
Went thru many videos to get this done conveniently. Everyone was using complex combinations for this. But this was so simple. Thank you. Subscribed.✅
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.👍👍
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.
Excellent work
Thanks for your simple way of explaining . One of the best excel trainer in English.
Best explanation ever i seen...
Explained in very simple terms.
Pleasant way of teaching. Brief and clear. I have been searching for this for quite sometime finally found a good teacher. 👍🏼
Super video sir.. no one can teach with this simple with indepth details.. thanks a lot
Here is another indian hero saving the world. Thank you so much
"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
Did you get solution on this
Very much helpful really liked it. 👍
Very nice , helpful & well explained video
simple way you have given us. thanks
This is the best way I have seen about this topic... Thank you!
Thanks for making it simple and Precise. I appreciate you 👍🏼
Love you tutorial point....I prefer your video instead of others
Very nice and clear to the Points.
Well simplified and nice presentations.
Keep it up !!
Good Luck !.
Thankyou somuch,So Informative,Love from Saudi Arabia.
Thanks! Learnt Drop down today.
Great Teaching, in short time, clear, precise n up to the mark!..
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
Great tip. I was looking for it.
Very useful informations, thanks for sharing such a beautiful video
Best and shortest explanation. Brilliant and Big Thanks
Sir aap jo b pdhate ho sbkuch achhe se clear ho jata h
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
Bro, You are a great teacher. Lot of love
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.
He is an excellent teacher for Ms. Excel.
Thanks for the tutorial, well self explanatory. Thanks very much and also wish if you can do the same in vba.
Thank you so much for this great help
wow best teaching style i have ever seen...thank u sir
This channel is gold.
This is FANTASTIC!
love your tutorial.thumbs up
really helpful, many thanks.
You are the best !!!!!!!!!!!
perfect sir, amazing and very easy steps with cool accent .. thanks and good wishes
wow you made it seem easy that's nice thanks
Your learning methods are ousam.
I like it 👍
Keep it
I learn from you all
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.
Brother you are doing an excellent job.. I have learnt a lot of functions from your videos...
Thank you sir, it is very helpfull
thanks a lot for sharing this. You were really great to put this in such a short span of time.
I have followed as you showed and it works..
TQ BRO EXPLAINED DETAILED.
Sir ,you are the best teacher ..
But sir please make a 1 video on shortcut keys
thank you!!!! this was made so simple!!!! love it
Thanks for making it simple and Precise. I appreciate you
Excellent and very easily understood, thank you very much
very much useful & so easy demonstration!!
Well explained. Thank you
Thanks you so much I learnt new thing today with this.
This guys explanations are so smooth
Easy to understand, good teacher 👍👍👍
Thanks alot... This really worked for me....
As usual Short & Sweet.!🤗
Thank you. Nice and very helpful tutorial
Very nicely explained. 👍👍👍
Hope this will help me in my work.
Very smart class!!
Nice... I hope u will teach us in a very simple language as usual.
Thanks a lot..
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.
I had a similar issue until I tried your solution. It worked! Thanks mate! ✌
Not understood please can you explain
@@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.
Very nice and helpful 😃
Very Short & Excellent...... 👍
Thanks a lot , you saved my time !
VERY CLEEEEEEEEEAN EXPLANATION. WOW.
Thanks a lot... It's short and clear
Very clearly mentioned
Great sir. Thank you so much
Easy way to understand , helped me lot
Thanks, very helpful!
Thank you.. the video was very helpful..
Excellent example and speech. Thank you
Sir,
Nice explanation
easy to understand
Thanks Sir
Good work brother. Very well explained. Thank you very much
Thanks for your nice & easy tutorial on conditional dropdown list.
Extremely helpful - thank you!
AMAZING VIDEO THANKS
U da Besssssttttt ı have been looking for this all-day! Thank you thank you thank you!
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?
@@ifeanyiadika6871 same here.. didn't helped me out..
Keep doing what you doing!.
Thanks a ton... thank you very much.....was just looking for this indirect function....you have made things just very simple.
You have made it look so easy thank you
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?
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 ......
Great learning sir
Nice explanation 👍
Thank you so much. my doubts are cleared now.
That was so simple. Thank you
Hi. The INDIRECT thing is not working in the data validation for me. The error shown is “The source currently evaluated to an error” Can you please help
Same