How to remove repeated email ids by macro?

H

Harshad

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

JBeaucaire

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-1059/2008/8/VBA-code-extracting-unique-1.htm

Hope this helps.

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

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

Shane Devenshire

Hi,

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