Quick Filter (for a list of values)
Create a filter feature where you can paste a list of values into a field and then the filter you are using will filter to all of those values.
Sometimes I receive lists of projects or people who I need to look into for reasons that don't fit into categories captured by other columns (such as, every completed project or everyone on a certain team). Trying to filter to 20+ projects out of a list of thousands by typing in each project ID and clicking "Add Selection to Current Filter" is a pain. When I receive an email from my client that says, "Hey can you look into X on these 20 projects," I would love to just copy the list of IDs she sent over into a filter on the project ID field rather than having to individually search for them.
I know this functionality is possible as I use it on a project management system we have and the feature accepts values separated by comma, space, or, most often used, paragraph (enter). When I copy a list of project IDs from a table in Outlook into this box, it knows what I am talking about and shows me only those items.
Anonymous
shared this idea
2 comments
-
Dan
commented
Thomas K, I have researched the advanced filter and unfortunately while it can approximate this functionality, it does not do what I am describing here. When I have an auto filter applied, I want the ability to paste in a list of values from a non-table source and have excel filter to only those values. The advanced filter requires me to clear my auto filter, process the data, and then I can only filter once based on the advanced filter criteria.
Maybe a better way to put it, if I paste 10 values into the search, it would be nice for it to return all 10 values rather than just allowing the first value I paste in there. That would be another way to get at what I am trying to do.
-
Thomas K
commented
The 'advanced filter' function that is already in excel does what you want.