Can Excel filter out a list based on a pasted list of values?

[Allan Sabado]

Hi Everyone,

Just joined this forum and hoping to learn more about excel. I got a quick question, say, I have a list of names I copied from a different excel file and pasted it on another file, is there a way for excel to filter another list based on the pasted values? Looking forward to hearing from you all soon!

 

[Hui]

Allan

Firstly, Welcome to the Chandoo.org Forums

You could use an Advanced Filter for that, Refer:
http://chandoo.org/wp/2011/10/10/how-to-use-advanced-filters/
http://chandoo.org/wp/2012/11/27/extract-subset-of-data/

 

[Allan Sabado]

Hi Hui,

Thanks a lot. This helped. However will advance filter work on cells with is of not the exact value? For example, my Criteria cell has a value of "Doe" and I want to filter out "John Doe"? would it be possible? I noticed that Advance filter only filters it based on the first few characters on a cell.

Thank you in advance!

 

[AIM]

Hi Allan,

You can filter by using a special character (*). In your criteria cell enter the value as *Doe. This will show all results that have the name "Doe" in it.

Regards!!

 

[Allan Sabado]

Thanks this really helped!