Look up values in one column and compare with another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

babypink2807@googlemail.com - 13 Nov 2007 16:42 GMT

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

Reply to this Message

Peo Sjoblom - 13 Nov 2007 16:54 GMT

http://www.cpearson.com/excel/Duplicates.aspx

Signature

Regards,

Peo Sjoblom

>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
[quoted text clipped - 17 lines]
>
> Thanks

Reply to this Message

Don Guillett - 13 Nov 2007 17:47 GMT

Look in the vba help index for FINDNEXT

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.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
[quoted text clipped - 17 lines]
>
> Thanks

Reply to this Message

Rate this thread: