View Single Post
 
Old 06-27-2012, 07:52 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote