SOLVED

Can I use Filter based on drop down list?

Copper 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 (Copper Contributor)
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

very much helpful - thank you @NikolinoDE 

1 best response

Accepted Solutions
best response confirmed by MPulse4 (Copper Contributor)
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

View solution in original post