Can I use Filter based on drop down list?
Hi, would there be a function I can use to summarize an overall list of selected names from the drop down (red highlighted area). I would like to create a overview and eliminate possible duplicates from the row of drop down names. (currently using goog spreadsheet)
How to filter data from drop down list selection in Excel?
This link, I will talk about how to filter data by using drop down list in one or two worksheets.
Creating a Drop Down Filter to Extract Data Based on Selection
In this link, you can how to create a drop-down filter in Excel so that you can extract data based on the selection from the drop-down.
Hope I was able to help you with these links.
