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?

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?

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?