Look up values in one column and compare with another

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
MS Excel Function (Find Duplicate values) 3
Excel VBA 1
Compare and Highlight Rows 12
How to look up and copy a changing range of data ? 2
Compare values in columns 5
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Concatenate with line breaks but ignore blank cells 3

Top