I would sort the rows (Data, Sort) and then delete the duplicated rows which
will be obvious. Take a note of the original row sequence before the first
sort so you can reresort it back to the original sequence after the deletion
(if required).

"gabarrao" wrote:


Hello,

I have a very big list of adresses and phones. There are a lot of
repeted data in it.
I would like to know if there is a way to erase the repeted rows of my
list automaticaly. If it is possible, how can I do it?

Thanks very much.

Matheus


--
gabarrao
------------------------------------------------------------------------
gabarrao's Profile: http://www.excelforum.com/member.php...o&userid=16885
View this thread: http://www.excelforum.com/showthread...hreadid=320598