Can I use Filter based on drop down list?

Occasional Contributor

google spread - summary.png


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)

2 Replies
best response confirmed by MPulse4 (Occasional Contributor)


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.


very much helpful - thank you @NikolinoDE