Extract Data Based on a Drop Down List Selection in Excel | Filter Data With Drop Down List Excel

------------------------------------------------------------

In this video I demonstrate how to filter or extract data based on a drop-down list selection in Excel. This method is only available to Excel 365 users. The functions used in this video are: UNIQUE, SORT and FILTER.

In the video I demonstrate how to extract data based on one drop-down list and then based on two drop-down lists.

The video will answer the following queries:
How do I extract data based on a drop-down list selection in Excel?
How do I filter data based on a drop-down list selection in Excel?
How do you populate data based on a dropdown selection in Excel?
What formula to use to pull data from a drop-down list?
How do I create a dynamic drop-down list Excel?
How do I filter data from a drop-down list in Excel?
How do I fetch data from a drop-down list?
------------------------

[MANUELHERNANDEZ-ofhx]

Saying this was useful is an understatement. You're a legend.

[AirHoward]

Absolute legend. Took me hours to find the right tutorial and this was exactly what i required. Very easy to follow

[IvanCortinas_ES]

This is the present and future of Excel, focused on dynamic array formulas and A.I. Thank you Chester!!! Another great tutorial!!

[nikhils]

This is absolutely amazing! Needed so many formulae in the older versions

[Foril]

I use Excel in my spare time and for work, I do not know why I just love working on excel and this video put a huge smile on my face. It is like a new toy to play with. Thank you so much for this video, I cannot wait to start using this information

[arregorn]

FINALLY! A solution that just makes sense! Thank you so much for this video!

[viewabhishek]

Best video on drop down sorting. Highly recommended.

[killswitch]

This is exactly what I have been looking for to create a digitized Inventory log of items going out to projects/foreman. This will help me with creating an end of year usage statistics. Thank you!

[asimsiddiq]

Respected sir, am your excel tutorials lover because you give creativity to do something new and new, thanks a lot.

[mainstreammirage]

Thanks so much mate, was given a task at work and this is exactly what I needed!

[jaody]

This is so great. You saved my life finding out how to do this in Macro. Thank

[ravisrinivasmurthy]

Great explanation! worked very well! Thank you

[KristofferAndersson-umfe]

This is 100% what I was looking for! Amazing, 10/10!

[pena_colada]

Extremely helpful you saved me hours of work, thank you!🎉

[DanielADeYoung]

Thanks... Just opened up a whole path for me to expand my reporting!

[AaronD]

This helped me immensely ! Now the limits are endless thank you!

[Liam-tmvz]

Thank you for this, I’ve been looking for this solution for a couple days now!

[jenitakurlawala]

So amazing, i created my manual invoice list into a statement with this video with number as a unique identifier ... wooohoooo .... excellent !!!!

[daylansiemann]

This is super helpful, thank you so much!

[becoached]

Fantastic thank you so much. Very very easy to understand your explanations too. I'm curious though, how would you return just the total value of sales per item especially as the data can continually expand?