Find unmatched rows between 2 worksheets

  • Thread starter Thread starter Rumy
  • Start date Start date
R

Rumy

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
 
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
Click to expand...

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