Find unmatched rows between 2 worksheets
 

Good Morning. I am running Excel 2007.I have 2 work sheets with the same type
of data.I need to match thw two and find the rows in one sheet which are not
in the other.Please help

Find unmatched rows between 2 worksheets
 

On Jan 12, 11:00*am, Rumy wrote:
Good Morning. I am running Excel 2007.I have 2 work sheets with the same type
of data.I need to match thw two and find the rows in one sheet which are not
in the other.Please help

If there is a column with unique values (like some kind of a primary
key) a simple VLookup will do it.