Look up values in one column and compare with another

  • Thread starter Thread starter babypink2807
  • Start date Start date
B

babypink2807

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
 
Back
Top