Solved

filter out rows that exist in another excel file

Posted on 2011-02-22
4
231 Views
Last Modified: 2012-06-21
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
Comment
Question by:jecommera
  • 2
4 Comments
 
LVL 24

Expert Comment

by:broomee9
ID: 34952258
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
 
LVL 38

Accepted Solution

by:
Aaron Tomosky earned 250 total points
ID: 34952307
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
 

Author Comment

by:jecommera
ID: 34953048
hmmm... dont really know Access.

Is there any way to do this in Excel?
0
 
LVL 24

Assisted Solution

by:broomee9
broomee9 earned 250 total points
ID: 34953072
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question