Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicate names
I have a spread sheet with about 5,000 names, addresses,
phone # and fax #. I would like to get rid of the duplicates... without doing them one by one or shift highlight then delete... can anyone help me? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicate names
Funny. I was just looking at this web page that demonstrates how to do
this. I haven't tried it myself but it is a place to start: http://j-walk.com/ss/excel/tips/tip47.htm "Ada" wrote in message ... I have a spread sheet with about 5,000 names, addresses, phone # and fax #. I would like to get rid of the duplicates... without doing them one by one or shift highlight then delete... can anyone help me? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicate names
Ada.
Say that the first name is in cell A2 Than in cell E1 (if it is empty, if not than use F1, if not than G1, ....) put the formula: =Countif(A:A,A2) fill this down to the last row. Than select all the rows and sort on column E ( or F, or G, or ...) All the 1's will float to the top and the remainder will be below them. Go to the first occurance of a 2 and select all the rows from there to the bottom. Than delete the rows. Clear the formulas and you are done. -- sb "Ada" wrote in message ... I have a spread sheet with about 5,000 names, addresses, phone # and fax #. I would like to get rid of the duplicates... without doing them one by one or shift highlight then delete... can anyone help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting duplicate names | Excel Worksheet Functions | |||
Deleting duplicate names | Excel Discussion (Misc queries) | |||
Duplicate names | Excel Discussion (Misc queries) | |||
How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
deleting duplicate names | Excel Discussion (Misc queries) |