in C1

=if(countif(A:A,B1)0,B1,"")

then drag fill down the column.

--
Regards,
Tom Ogilvy


"Martin" wrote:

Hi all,

This is probably something very simple. I have two columns that I need to
compare for duplicates. So I have columns A and B, I need a macro that will
compare the data in column A with the data in column B then copy any
duplicates to column C.

Can someone provide some code?

Thanks.

-B