Comparing 2 lists to display only records in 1 but not in both lis

C

Craig

Hi,

Using Excel 2003 and 2007....Is there a quick way to compare two separate,
large, but similar data lists together and display only those rows (records)
that are in one of the two lists but not in another?

for example:

Data List 1:
Name, Dept
Smith, Accounting
Jones, Sales
Robinson, Shipping

Data List 2:
Name, Dept
Smith, Accounting
Jones, Sales

So I could easily see that the record "Robinson, Shipping" was in list 1 but
not in list 2.

thank you very much

Craig
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing two lists in Excel 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Comparing two lists 0
Multiple lists 2
Cascade Drop-Down Lists? 1
Populate empty cells to use for conversion 1
How to mail merge multiple rows in one document 0
Compare 2 lists / conduct gap analysis (XL 2007) 5

Top