How to delete repeted rows automaticaly?
 

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

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

Hello,

I have already done this. But even this way the list is too big. I
would like to find and automatic way.

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

"gabarrao" wrote in message
...

Hello,

I have already done this. But even this way the list is too big. I
would like to find and automatic way.

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


This macro assumes your data starts at row 1, that column A is the one you
want to test for duplicates and that the data has been sorted on column A.
Change the Row= and Col= lines to change the target cells.

It will keep the first row of any dupes and continue until it finds a 2
blank cells.

Sub deletedupes()
Row = 1
Col = 1
Do Until Cells(Row, Col).Value = ""
Cells(Row + 1, Col).Activate
If Cells(Row + 1, Col) = Cells(Row, Col) Then
ActiveCell.EntireRow.Delete
Else
Row = Row + 1
End If
Loop
End Sub

Ian

DataFilterAdvanced Filter

Check "unique records only" and "copy to another location".

For more on this method see Debra Dalgleish's site

http://www.contextures.on.ca/xladvfilter01.html

Gord Dibben Excel MVP

On Fri, 26 Nov 2004 11:35:14 -0600, gabarrao
wrote:


Hello,

I have already done this. But even this way the list is too big. I
would like to find and automatic way.

Thanks very much,

Matheus

Hi,
I wrote something recently for another user and the main
problem was that although I created each string in upper
case it does not take into account that one cell had ST
and the other cell had Street. You have to make sure that
rrepeated lines are actually repeats, word for word. Send
me your email and I will send it to you.



- -mark

see my excel stuff:
http://au.geocities.com/excelmarksway
http://www.geocities.com/excelmarksway

-----Original Message-----

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?
action=getinfo&userid=16885
View this thread:
http://www.excelforum.com/showthread...hreadid=320598

.