Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing Duplicates
XL 2002 SP3, Win XP HE SP1
Follow up to: microsoft.public.excel.misc Hi, what is the BEST way to remove duplicate cells (phone numbers, email addresses, etc.) from a long list in Excel? The duplicates usually would be in 1 column (Column "A: for example) Tx. S |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing Duplicates
Hello An easy way is to just press control F then click the replace tab enter what you want removing in the "find what field", leave the "replace with" field blank & then click replace all. This will remove all of what was selected, however it will leave gaps in you list this can either be sorted or you could write some Vb to remove the gaps. Hope this helps -- robmeister ------------------------------------------------------------------------ robmeister's Profile: http://www.excelforum.com/member.php...o&userid=24364 View this thread: http://www.excelforum.com/showthread...hreadid=380208 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing Duplicates
Try using advanced filter. Date, filter, advanced filter, select unique
records and copy to another range. "robmeister" wrote: Hello An easy way is to just press control F then click the replace tab enter what you want removing in the "find what field", leave the "replace with" field blank & then click replace all. This will remove all of what was selected, however it will leave gaps in you list this can either be sorted or you could write some Vb to remove the gaps. Hope this helps -- robmeister ------------------------------------------------------------------------ robmeister's Profile: http://www.excelforum.com/member.php...o&userid=24364 View this thread: http://www.excelforum.com/showthread...hreadid=380208 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Duplicates Help | Excel Discussion (Misc queries) | |||
Removing duplicates | Excel Discussion (Misc queries) | |||
removing duplicates | Excel Discussion (Misc queries) | |||
Removing Duplicates | Excel Discussion (Misc queries) | |||
removing duplicates | Excel Programming |