Advance Sort & Filter

[amir11050]

Hello Everyone,

I have data in two sheets that need to be sorted. I need to create a list of records that are on the first list but NOT on the 2nd list. I was wondering how I could sort these records out using the name columns (2) and filter into a new sheet.

Thank you!

 

[AhoyNC]

This video shows how to do it with a helper column.

http://www.youtube.com/watch?v=0Ns2_2v7E0c&feature=plcp

 

[amir11050]

Thank you so much for this. It has been helpful. I was, however, wondering now that i have my extracted emails; how can I do an exact match with the names and zip codes. I have tried using the match function, but it is not finding anything. Would love some help! thanks!!

 

[AhoyNC]

If you post a sample of your data someone should be able to help you.
If you use Internet Explorer just put a border around the data and then copy and paste into forum.