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

Excel Comparing two columns 1
Multiple lists 2
Sorting 2 lists 1
Sort by Total 7
Comparing two lists of data 2
Comparing 2 spreadsheets to remove duplicate names 2
Compare 2 lists / conduct gap analysis (XL 2007) 5
Populate empty cells to use for conversion 1

Top