• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • Last Modified:

filter out rows that exist in another excel file

I will be uploading a new list of email addresses into our system.
I have two csv files, both lists of emails and their attributes. The first is the main list and the second is a list of email I need to filter out of the first list.

How do I create a excel csv file that contains a new list that is the original with the second list filtered out.

thanks
0
jecommera
Asked:
jecommera
  • 2
2 Solutions
 
TracyVBA DeveloperCommented:
What do you mean by filtered out?  Do you want all emails from the original lists and just new emails from the second list?
0
 
Aaron TomoskyTechnology ConsultantCommented:
Import them into access as two different tables. Thenthere are easy ways to combine them like:
insert into table1 select * from table2 where email not in (select email from table1)
0
 
jecommeraAuthor Commented:
hmmm... dont really know Access.

Is there any way to do this in Excel?
0
 
TracyVBA DeveloperCommented:
If you're looking for the unique values from both lists combined, then use an autofilter.

See this article on how to use the Unique Auto Filter feature:
http://pcunleashed.com/excel/how-to-get-unique-values-in-excel/
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now