PDA

View Full Version : How to filter multiple values



JackkG
09-07-2015, 08:26 AM
Hello,

I have a sheet wherein one column have multiple set of values, i was wondering how to filter for a unique value. Can someone help me out here. An example is given below. Client-Regions column have multiple set of records in single cell, say if I want to filter on "New York", how to do it. Thanks!







Client - Regions







New York







New York, Canada







Brazil







Brazil







Brazil, New York,Canada







New York, Brazil

JKwan
09-07-2015, 08:50 AM
have you try using a FILTER then set a criteria of CONTAINS New York?

JackkG
09-07-2015, 08:56 AM
Yep, i got that. But is there a way to display just "New York" and to exclude or hide other text in that cell?

mancubus
09-08-2015, 12:48 AM
filtering makes rows visible whose cells in filter column meet the auto filter criteria, and does not change the cell contents and ws structure.

clear unwanted content from cells in auto filter range.
you can copy the auto filter range to some other location and remove them in that location as well.