How to match the Coloums

[anshulgr8]

Hi I have a list of Alphabets in coloum 'A' and 'B' .
For example Coloum A has - A, AA, AB, AC, AD, AE

But coloum B has- A , AA, AB, AD ,AE (does not have AC)
I want to match both the coloums and delete the ones which are whic
are extra in coloum A.

Please help me
Thank

 

[Guest]

Hi

Have a look here for some help:
http://www.cpearson.com/excel/duplicat.htm

Hope this helps.
Andy.