Hi SaneMan,
To find out which records on Sheet2 are not found in Sheet 1, you could use a formula like:
=IF(COUNTIF(Sheet1!C:C,Sheet2!C2)=0,Sheet2!C2,"")
where 'C' is the data column.
This will return a discontiguous list of unmatched records.
To do it for both sheets, you'd also need a separate test for:
=IF(COUNTIF(Sheet2!C:C,Sheet1!C2)=0,Sheet1!C2,"")
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|