How to match the Coloums

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 which are extra in coloum A.

Please help me
Thanks

Hi

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

Hope this helps.
Andy.

"anshulgr8" <anshulgr8.24tjcz_1142606704.7043@excelforum-nospam.com> wrote
in message news:anshulgr8.24tjcz_1142606704.7043@excelforum-nospam.com...
>
> 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 which
> are extra in coloum A.
>
> Please help me
> Thanks
>
>
> --
> anshulgr8
> ------------------------------------------------------------------------
> anshulgr8's Profile:
> http://www.excelforum.com/member.php...o&userid=32563
> View this thread: http://www.excelforum.com/showthread...hreadid=523564
>