duplicate names

[Ada]

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?

 

[Elias]

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

 

[steve]

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.