non-duplicated values
 

I have data in columns A and B on spreadsheet one. I need a macro that will
look down column B and then look down column A and list in column C only the
values that are not duplicated in both columns A and B. In other words, I
need the unduplicated items to be listed in column C.

non-duplicated values
 

See Chip Pearson's page on working with duplicates and uniques

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy


"scrabtree23" wrote in message
...
I have data in columns A and B on spreadsheet one. I need a macro that
will
look down column B and then look down column A and list in column C only
the
values that are not duplicated in both columns A and B. In other words, I
need the unduplicated items to be listed in column C.