removing duplicates in list macro needed

[ad9051]

Is it possible to remove duplicates from a range of cells? Via macro! I.e. if a document contains a list of names and data, and name appears more than once, delete than name and the associated data coluns to the right and left?

All the best Alan

[tigeravatar]

Alan,

Give this a try:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[ad9051]

I am a big fan of tiger avatar, ill give it a whirl! Cheers Alan

[ad9051]

Works many thanks Alan