How to remove repeated email ids by macro?
 

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

How to remove repeated email ids by macro?
 

Run this macro. It will ask you to highlight your range of email addresses,
then ask you to select a range of cells to copy your unique values to. Make
sure you pick enough cells for the second range to receive the new list.

The code is on this page, be sure to use the SECOND version further down the
page:

http://en.allexperts.com/q/Excel-105...g-unique-1.htm

Hope this helps.

-
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Harshad" wrote:

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

How to remove repeated email ids by macro?
 

Dear JBeaucaire,

The second code is working.


Thanks
Harshad

"JBeaucaire" wrote:

Run this macro. It will ask you to highlight your range of email addresses,
then ask you to select a range of cells to copy your unique values to. Make
sure you pick enough cells for the second range to receive the new list.

The code is on this page, be sure to use the SECOND version further down the
page:

http://en.allexperts.com/q/Excel-105...g-unique-1.htm

Hope this helps.

-
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Harshad" wrote:

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

How to remove repeated email ids by macro?
 

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

How to remove repeated email ids by macro?
 

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