If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos. Here are some other similar videos you may find useful: ✅ Dynamic Filter in Excel - Filter As You Type (with & without VBA) - th-cam.com/video/xBRkCv6RWcE/w-d-xo.html ✅ Advanced Filter in Excel - th-cam.com/video/ZUFEqjDLM2I/w-d-xo.html Also, I have made all of my courses available for FREE. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course
I just have to say that I don't leave many TH-cam video reviews. But after looking at videos/answers for an interesting Excel problem that I had, I have to say that this is very well done, if you do it step by step. Having somewhat of a programmer background, I overthought this six-ways-from-Sunday... looked at probably 100 other videos... and ended back here. Just do everything like he says. If you can't lock by hitting "F4," type it in. Do it all on one sheet, and if you have to copy the newly-created dynamic table to another sheet, do it at the end. If you have more columns, that's okay; just append to the right of what he displays. It's a really good way around macros if those are the types of things that are blocked at your work, for whatever reason. Nailed it! Thanks man.
This tutorial is amazing. It's not exactly what I was looking for but it taught me so much and I was able to make some slight adjustments to provide a resolution to our business problem. I was struggling for hours with VLOOKUP, but this did the trick. The screen capture is clear, the instructions precise and easy to follow. Thank you for such high quality content!
I was really looking for this method for few years. But today i came upto this video and it finally ended my search. Now i will start practicing. Thank you so much for this so easy but technical solution.
Very good instructions. I used your idea to develop something i was working on. If i had not found this video, i would not have been able to finish my project. Thank You.
I felt I really should thank you for sharing this. My manager was so impressed by this. Keep doing the good work. Because it is dynamic, it will come handy. Good job!
OMG.. I was searching all night for help with this formula. You are the only person I found with a video that made this actually make sense for the average person. Thank you so much. Really impressed.
Thanks Sumit, although here are various trainers here on youtube but I seem to find your techniques most useful and apt for my requirements. Keep up the good work !
This was very helpful! I was trying for a week to make a catalog, I was using all kinds of ways, and finally found this simple one! Thank you very much! I just need to add pictures seperatly
This is was SO helpful! I was searching for DAYS to find the correct video. This told me exactly what I needed to do. Thank you SO much!! Continue the awesome work! 😊😊😊
This is very useful. I have a spreadsheet where I select the product category, using your information it now pulls in all the vendors who are in a certain product category. What I would like to do next is have a drop down or data validation that pulls in the returned vendors (from the product category search) in the list. Once I select a vendor it would return that vendor contact information.
This is an amazing piece of knowledge. I was thinking about similar usage for preparing a menu costing for a hotel. This gives a new dimension to go forward. Thank you Sumith, May you reveal new ways of doing things in Excel !!!
Amazing! Mega helpful, very descriptive step by step! I didn't use Excel for a long time and was able to pick up very fast, due to your great explanation! Thank you again!
This is a most excellent explanation with intermediate steps very clearly explained. Thanks. The next step would be to indicate how you deal with the dataset expanding or contracting, something that happens often in real life.
Thanks for this tutorial. I used this today and it worked like a charm. Your video saved me hrs of trial and error in my dashboard. So appreciative. 🙏🏽
Thank you!! been struggling with how to present this kind of data! such a life saver😅 I've been beating myself coz I dont seem to input any working formula for the result I want and here you are😇🙏🙏
Thanks for this video it has helped me understand INDEX, ROWS, and COLUMNS. I have now completed something in excel I have wanted to do for a while and couldn't work it out. Keep up the good work.
Wonderful Job, I was looking forward for this method, but I wanted instead of country using dates, I made the change and it works perfectly. nice thanks man, and thanks God.
Thank you so much for this tutorial and worksheet. This helped me create my dynamic lists in Mac Numbers. I've been fighting with it for a week. Now it just automatically updates. Totally thrilled :D
Thanks Sumeet. Just what I was looking for. Though nicely explained "WHAT IS DONE", however since "WHY IS WHAT DONE" was not so clear hence took a while to understand it.
This tutorial was amazing, it helped me alot. Please keep uploading these videos to people like me to learn Thank you. Will look forward for your other tutorial videos.
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos.
Here are some other similar videos you may find useful:
✅ Dynamic Filter in Excel - Filter As You Type (with & without VBA) - th-cam.com/video/xBRkCv6RWcE/w-d-xo.html
✅ Advanced Filter in Excel - th-cam.com/video/ZUFEqjDLM2I/w-d-xo.html
Also, I have made all of my courses available for FREE. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
Dear sir
How can we use same in Google sheet. Pls help me to do this.
I am struggling to do same in Google sheet.
great application , is this workout example sheet available ?
@@RijuA1984 You can download the file from here: trumpexcel.com/extract-data-from-drop-down-list/
@@PiyushKumar-wl7py Google Sheets has a FILTER function that can do this. Have a look at this - spreadsheetpoint.com/filter-function-google-sheets/
how to use helpers with 2 criteria
I just have to say that I don't leave many TH-cam video reviews. But after looking at videos/answers for an interesting Excel problem that I had, I have to say that this is very well done, if you do it step by step.
Having somewhat of a programmer background, I overthought this six-ways-from-Sunday... looked at probably 100 other videos... and ended back here. Just do everything like he says. If you can't lock by hitting "F4," type it in. Do it all on one sheet, and if you have to copy the newly-created dynamic table to another sheet, do it at the end. If you have more columns, that's okay; just append to the right of what he displays.
It's a really good way around macros if those are the types of things that are blocked at your work, for whatever reason.
Nailed it! Thanks man.
This tutorial is amazing. It's not exactly what I was looking for but it taught me so much and I was able to make some slight adjustments to provide a resolution to our business problem. I was struggling for hours with VLOOKUP, but this did the trick. The screen capture is clear, the instructions precise and easy to follow. Thank you for such high quality content!
Please Subscribe me Dear
shut up corona
This video was able to help me extracting data from 28k rows. The best video I've ever watched.
Happy to know the video helped :)
I would love to say this is one of the most helpful excel videos I have ever watched and I have used this multiple times at my job! Thank you!
I was really looking for this method for few years. But today i came upto this video and it finally ended my search. Now i will start practicing.
Thank you so much for this so easy but technical solution.
Extremely helpful and showed multiple excel functions inside one video. It helped me a lot!. Thanks!
Glad you found it useful Ratna!
Very good instructions. I used your idea to develop something i was working on. If i had not found this video, i would not have been able to finish my project. Thank You.
Thank you so much. After hours and hours browsing through different solutions came across your video. Very clear and insightful. Thank you again
So far I have referred many videos on Excel as well as VBA from this channel. I liked it very much. Good work and keep me posting.
I felt I really should thank you for sharing this. My manager was so impressed by this. Keep doing the good work. Because it is dynamic, it will come handy. Good job!
The best video on internet for this topic. You saved me !!Thanks alot
What a phenomenal solution that can be used in so many circumstances. Thank you for the clear and through explanation!
This is going to make homeschooling so much easier!!! Thank you!!!!
OMG.. I was searching all night for help with this formula. You are the only person I found with a video that made this actually make sense for the average person. Thank you so much. Really impressed.
I am not going to lie but when i follow along with your video I feel like a genius when it works!!!!!!
After 8 years I just stumbled across this video and it was exactly what I needed for a project at work
THANK YOU SO MUCH, THIS IS SUCH A BIG HELP WITH OUR THESIS COMPUTATION
Thanks Sumit, although here are various trainers here on youtube but I seem to find your techniques most useful and apt for my requirements. Keep up the good work !
This was very helpful! I was trying for a week to make a catalog, I was using all kinds of ways, and finally found this simple one! Thank you very much! I just need to add pictures seperatly
I was looking for something handy and straightforward, for quite a long time. this one is one of the best. thank you for sharing and for being precise
Why can't we use filter instead of using all these formulaes
th-cam.com/video/b1SX4wMWMq0/w-d-xo.html
This is what I was searching for quite sometime. Really explained well. But I need to view few more times to understand each formula. Thanks.
Thank you for a very easy to follow tutorial...this video enabled me to accomplish this difficult function quite easily. Much thanks...
Very clear step-by-step explanation. thank you! SUBSCRIBED
Very helpful, and this video was posted 8years ago! Salute sir!
This is was SO helpful! I was searching for DAYS to find the correct video. This told me exactly what I needed to do. Thank you SO much!! Continue the awesome work! 😊😊😊
This is very useful. I have a spreadsheet where I select the product category, using your information it now pulls in all the vendors who are in a certain product category. What I would like to do next is have a drop down or data validation that pulls in the returned vendors (from the product category search) in the list. Once I select a vendor it would return that vendor contact information.
Simple & useful for finance & non-finance guys to prepare data models.
You explained it in very simple way. Thanks!
This is an amazing piece of knowledge. I was thinking about similar usage for preparing a menu costing for a hotel. This gives a new dimension to go forward. Thank you Sumith, May you reveal new ways of doing things in Excel !!!
Very helpful tutorial. It had the exact answers that I was seeking. Thank you sir.
Amazing! Mega helpful, very descriptive step by step! I didn't use Excel for a long time and was able to pick up very fast, due to your great explanation! Thank you again!
Glad you found the video useful!
Exactly what I was looking for. And your presentation is so good. Very easy to understand. Thank you lot
what a man you are, really excellent , today I understood excel means excellent. from Malaysia
This is a most excellent explanation with intermediate steps very clearly explained. Thanks. The next step would be to indicate how you deal with the dataset expanding or contracting, something that happens often in real life.
Exactly what I've been looking for! THANK YOU!!!
Thank you so much for this video. super helpful for me. God bless you. thank you again
Thanks ! Beautiful extract data on a drop-down list selection......................... thanks sir !
Thank You Very Much! I am eagerly awaiting your video about Excel to XML format to export to tally.
Thank you so much, I would give you an 8 star rating if I could :)
This is exactly what I've been looking for, thanks for sharing. Subbed.
A wonderfully clear yet detailed project that has helped me enormously, many many thanks.
Thanks for this tutorial. I used this today and it worked like a charm. Your video saved me hrs of trial and error in my dashboard. So appreciative. 🙏🏽
Thank you!! been struggling with how to present this kind of data! such a life saver😅 I've been beating myself coz I dont seem to input any working formula for the result I want and here you are😇🙏🙏
This is exactly what I was looking for. Indian tech gods are where I learn my excel info now days lol
This video just solved my problem! Thank you so much
Glad the video helped 🙂
Superb Bro. It helped me alot. Thank you soo much for your effort.. worth alot.. Thank you and keep the good work up.
Thanks for this video it has helped me understand INDEX, ROWS, and COLUMNS. I have now completed something in excel I have wanted to do for a while and couldn't work it out. Keep up the good work.
This video helped me to put a my Food menu & required items list :) Thanks bro!
Thank you. You have explained it well and quickly. I have a better understanding of ROWS, COLUMNS & INDEX.
Very helpful video, great content
I know I'm late, but a few rewinds and I was able to duplicate your process. Very good work Sir. Keep it up!
Really Awesome & Superb, Thank YOU more.... Keep growing..
Very Nicely and clearly explained. Thank you
Glad you found the video useful!
Wonderful Job, I was looking forward for this method, but I wanted instead of country using dates, I made the change and it works perfectly. nice thanks man, and thanks God.
Thank you so much for sharing, this is a very informative, easy to follow video. Very much appreciated :)
Such a nice lesson I have ever learned...... Thanks a lot
Thank you so much Bro!! God bless you for sharing it really helped our team so much!!
Glad you found it useful :)
Exactly what I required. Excellent Video, clearly explained Thank you....
This tutorial is amazing. I love it. Exactly what I was looking for. Thank You so much.
thank you so much brother. really helpful for my business.
I searched 10 previous videos but only this showed me how to get it done!
Awesome work with a clear voice!! Thank you Trump!!!!
WOW! you are a super teacher bud.
This was very useful fantastic video, thank you
This is a good alternative for making a manual report instead of using a pivot table.
Super useful content! Thank you!
Perfect!!!! Thanks a lot! I have just subscribed!
VERY NICE VIDEO, IT WILL BE WORKING DATE AND TIME FORMAT ALSO, LOT OF THANKS
Found all the answers needed in one place. Thank you!
Thank you! I'm using it for something private and this will help me a lot. :)
Thank you so much for this tutorial and worksheet. This helped me create my dynamic lists in Mac Numbers. I've been fighting with it for a week. Now it just automatically updates. Totally thrilled :D
Glad the video helped Tina!
Thank you, this was really helpful.
Excellent video.
Excellent tutorial. Keep up the good work and please publish more Excel tips.
Excellent tutorial!
Thanks friend really help me with my work thumbs up
Oh man, this exactly what I was looking for. Thanks for sharing.
excellent. many thanks for your effort and for sharing
Fantastic, great that you took me from concept to outcome, and I managed multiple sheets and drop-down menus as well.
Great video! Thank you for your help!
Thanks Sumeet. Just what I was looking for. Though nicely explained "WHAT IS DONE", however since "WHY IS WHAT DONE" was not so clear hence took a while to understand it.
This tutorial was amazing, it helped me alot. Please keep uploading these videos to people like me to learn Thank you. Will look forward for your other tutorial videos.
That's so useful! Thanks a lot!
This is exactly what I was looking for. Great tutorial. Very simple. Love using Index function.
Thank you so much, extremely useful and brilliant !
Thank you so much dear for sharing such a nice and informative video
Great video. Very easy to follow. Thank you.
Thank You So Much dear.
It helps me Alot
Exactly what I needed. This was great!
Great video!! Thanks a bunch!!
This was extremely helpful. Excellent tutorial!
Thanks a lot exactly what i was looking for
Glad you found the video useful!
Thank You so much ... Very simple
Great post, good work, well done...
After long time problem got resolved. Thank you so much :)
Simple and So Effective. Thanks a lot for this video. Learnt so much. I was planning to write a VBA program to do this. Excel is great tool
well done ! the best solution
That's an absolute genius! Amazing!
dude this is exaclty what i wanted
legend