Thank you for further information,
Actually i'm using Exl 2000.

Thank you again.

"Shane Devenshire" wrote:

Hi,

If you are using 2007, no need for a macro, just choose Data, Remove
Duplicates.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Harshad" wrote:

i have so many repeated mail ids, i want to sort it, so that it remove all
repeated mail ids.
Pls help