Macro to Compare Columns A & B and dispaly any duplicates in Columns C & D

Many thanks to JBeaucaire & martindwilson for taking the time to get back to me it is very much appreciated.

Having said that, my colleague has ever so slightly changed the goals posts !

What he has is two columns of Text i.e. columns 'A' and 'B' and what he would like is a macro to generate the following:-

(a) In column 'C' he wants a unique list of data from columns 'A' & 'B' i.e. no duplicates.

(b) In column 'D' he wants a list of items that only appear in column 'A'

(c) In column 'E' he wants a list of items that only appear in column 'B'


Any assistance would be most welcomed.

Best Regards


Rob


N.B. Excel version 2003

Original Request resolved- many thanks to all who replied

Thanks again


Regards


Rob