Clear Duplicates in Column A to Z

[eltonlaw]

Dear Expert,

May I know how to clear duplicates via VBA please?

A1 to C11 are original.
E1 to G11 is expected outcome.

Thanks so much,
Thanks

[JapanDave]

I am not clear on what you want to stay?

[eltonlaw]

Hi,
Say A1 to C11 is like this.
Data in A2 to A5 are duplicated from A1.
Date in A8 to A11 are duplicated from A7
Would like to use VBA to clear the duplicated and display in Column E.
Thanks
Elton


A123 XXX HK
A123 XXX GM
A123 XXX GM
A123 XXX FM
A123 XXX FM
A123 XXX BL
A126 YYY HK
A126 YYY HK
A126 YYY HK
A126 YYY GM
A126 YYY GM

[Marcol]

Would this formula in E2 not do as you need?

Please Login or Register  to view this content.

Drag Across then Down

Copy the result and Paste Special > Values if you need to.