Posted to microsoft.public.excel.newusers
|
|
Look up values in one column and compare with another
http://www.cpearson.com/excel/Duplicates.aspx
--
Regards,
Peo Sjoblom
" wrote in message
oups.com...
I have a column in one worksheet and a column in another worksheet
(both in the same workbook). The list is huge and I need to check one
column against another for duplicates and remove the duplicate from
one column
Worksheet 1
A101111
A101222
B023455
B334455
Worksheet 2
A102222
A101222
B023333
B224455
How do I create a formula to look up the duplicate and highlight it so
that I can delete it from worksheet 2?
Thanks
|