Compare and output unique

[ih8elvis]

Hello All,

I’m trying to understand how I can compare two columns of data an
output the unique values.

For example, column C contains data from C3:C92 and column J contain
new data from J3:J17 (both columns are formatted the same i.e
80333-ALLxxxx). How can I compare J to C and output the unique values?

I’m sure it’s simple, but then again I got a C- in programming……..

Thanks!

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique

 

[ih8elvis]

Thanks!