Can I use Filter based on drop down list?

[MPulse4]

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 · Accepted solution]

@MPulse4 

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.

NikolinoDE

[#3]

very much helpful - thank you @NikolinoDE