non-duplicated values

[scrabtree23]

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.

[Tom Ogilvy]

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

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

--
Regards,
Tom Ogilvy


"scrabtree23" <[email protected]> wrote in message
news:[email protected]...
> 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.