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.
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.
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
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.
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 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?
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)
Thank you. This video is amazing and simple than other videos in RUclips. But when I practice it will fail. Error msg "The source currently evaluates to an error. Do you want to continue?" Sir What's the solution for this error?
It appears when the Origin cell, in this case the countries, has nothing selected. First you need to select something from the origin and then apply the formula to the dependent cell.
@@diobelys1992 I keep getting "a named range specified cannot be found" after doing =INDIRECT +...??? searched the internet couldn't understand anything
Hi. Either your first drop down is empty before adding indirect formula or your table has multiple names, go to table names, check there might be 2 names redirecting you to same table. Get these resolved, it'll work perfectly. Subscribe to my channel for more tips n tricks 😊
Hi, Do check if the table names have some special characters. Only 'underscores' are allowed. I faced the same error since one of my table name had a '/' in it. I replaced it with '_' and problem solved.
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "RUclips12" 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
simple ...to the point ....value for your time and need ....no cliche....👍👍
Here is another indian hero saving the world. Thank you so much
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.
Went thru many videos to get this done conveniently. Everyone was using complex combinations for this. But this was so simple. Thank you. Subscribed.✅
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.
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
you people have all the tutorials i ever need for excel great videos
You are an excellent teacher! You make everything so straightforward! Thank you. Feb. 6, 2021
Thanks for your simple way of explaining . One of the best excel trainer in English.
Incredible tutor, brilliant explanation - very precise and clear. Thanks a lot.
He is an excellent teacher for Ms. Excel.
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
Pleasant way of teaching. Brief and clear. I have been searching for this for quite sometime finally found a good teacher. 👍🏼
Excellent video without any nonsense...Thanks !
This channel is gold.
Sir aap jo b pdhate ho sbkuch achhe se clear ho jata h
This is the best way I have seen about this topic... Thank you!
Best and shortest explanation. Brilliant and Big Thanks
Bro, You are a great teacher. Lot of love
wow best teaching style i have ever seen...thank u sir
This guys explanations are so smooth
Great Teaching, in short time, clear, precise n up to the mark!..
Thankyou somuch,So Informative,Love from Saudi Arabia.
Brother you are doing an excellent job.. I have learnt a lot of functions from your videos...
Super video sir.. no one can teach with this simple with indepth details.. thanks a lot
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.
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 !.
I have followed as you showed and it works..
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
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.👍👍
Best explanation ever i seen...
Explained in very simple terms.
Easy to understand, good teacher 👍👍👍
Your learning methods are ousam.
I like it 👍
Keep it
I learn from you all
Thanks for making it simple and Precise. I appreciate you 👍🏼
Thank you so much, I was looking to find exact solution & thanks for explaining it so well
Very nice , helpful & well explained video
As usual Short & Sweet.!🤗
Nice... I hope u will teach us in a very simple language as usual.
Thanks a lot..
perfect sir, amazing and very easy steps with cool accent .. thanks and good wishes
Thanks alot... This really worked for me....
Very Short & Excellent...... 👍
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.
Excellent example and speech. Thank you
very much useful & so easy demonstration!!
Thanks! Learnt Drop down today.
Sir ,you are the best teacher ..
But sir please make a 1 video on shortcut keys
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 ......
Excellent and very easily understood, thank you very much
Keep doing what you doing!.
You have made it look so easy thank you
Very useful informations, thanks for sharing such a beautiful video
thanks a lot for sharing this. You were really great to put this in such a short span of time.
Very nicely explained. 👍👍👍
Hope this will help me in my work.
Thank you. Nice and very helpful tutorial
Extremely helpful - thank you!
Thanks for the tutorial, well self explanatory. Thanks very much and also wish if you can do the same in vba.
Easy way to understand , helped me lot
simple way you have given us. thanks
Very much helpful really liked it. 👍
Thanks a lot... It's short and clear
Good teaching, I like this.
You are the best !!!!!!!!!!!
Sir,
Nice explanation
easy to understand
Thanks Sir
thank you!!!! this was made so simple!!!! love it
Thanks you so much I learnt new thing today with this.
This is FANTASTIC!
Excellent way of presentation. Weldon bro. Keep it up 🙂
Thanks a lot , you saved my time !
Very clearly mentioned
To add more data to the list so that the list expands is there a special formula? Great video! Thank you
Thanks for your nice & easy tutorial on conditional dropdown list.
Good work brother. Very well explained. Thank you very much
Thanks for making it simple and Precise. I appreciate you
Thanks a ton... thank you very much.....was just looking for this indirect function....you have made things just very simple.
Great tip. I was looking for it.
Very smart class!!
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?
Great video. Although I am curious as to whether this can be done across a vertical list? Thanks 😊
same question ....have you found about this solution?
Excellent… I have a question you just make it only for one row, If want it more then one then what is the procedure, Pls advice waiting for your reply
Thank you.. the video was very helpful..
Thanks for the beautiful explanation
Thank you so much. my doubts are cleared now.
Excellent sir... Thank you so much
love your tutorial.thumbs up
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)
TQ BRO EXPLAINED DETAILED.
Thank you so much for this great help
Great learning sir
Ultimate sir ur knowledge
If there are Countries, State and cities, how to apply Data validation? Please let me know.
Thank you. This video is amazing and simple than other videos in RUclips. But when I practice it will fail. Error msg
"The source currently evaluates to an error. Do you want to continue?"
Sir What's the solution for this error?
It appears when the Origin cell, in this case the countries, has nothing selected. First you need to select something from the origin and then apply the formula to the dependent cell.
@@diobelys1992 I keep getting "a named range specified cannot be found" after doing =INDIRECT +...??? searched the internet couldn't understand anything
I too got same error
Hi. Either your first drop down is empty before adding indirect formula or your table has multiple names, go to table names, check there might be 2 names redirecting you to same table. Get these resolved, it'll work perfectly. Subscribe to my channel for more tips n tricks 😊
Hi, Do check if the table names have some special characters. Only 'underscores' are allowed. I faced the same error since one of my table name had a '/' in it. I replaced it with '_' and problem solved.
Well explained. Thank you
Awesome session.👍
VERY CLEEEEEEEEEAN EXPLANATION. WOW.