Compare Columns
 

Is there a way to compare two columns and create a new column with only
the items that do not match? I have two lists that should match however
they do not. I want to compare the two columns and move the difference
to a third?

Thanks Mike

Hi
as a starting point:
http://www.cpearson.com/excel/duplic...#InOneNotOther

--
Regards
Frank Kabel
Frankfurt, Germany

"Michael Nesi" schrieb im Newsbeitrag
...
Is there a way to compare two columns and create a new column with
only
the items that do not match? I have two lists that should match
however
they do not. I want to compare the two columns and move the
difference
to a third?

Thanks Mike