| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove duplicated data repeated.... | Excel Worksheet Functions | |||
| How to remove duplicated data repeated in a column and keep just o | Excel Worksheet Functions | |||
| How do I create an email macro to auto fill the email? | Excel Discussion (Misc queries) | |||
| Merging adjacent repeated columns with a macro | Excel Discussion (Misc queries) | |||
| how do I remove repeated data in excel | Excel Worksheet Functions | |||
![Harshad[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
