Try this beauty from my archives:
http://savefile.com/files/1571748
Extract numbers in List B not in List A.xls

It'll work equally good for text, too
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
---
"Craig" wrote:
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