Excel: Re: How to delete duplicate rows

Oh, yeah...that saves me tons of time. Thanks! I always
forget about
"Paste | Special".

> I tried it and it gave me the same message ...
"no cells found" ... I =
> used this formula starting in row 3 (data starts in row
2)
> =3DIF(A3=3DA2,"duplicate","")
>
> From here, you could always paste that column as values
only, then sort =
> by that column. That would put all your duplicates
together, making them =
> easier to delete ...
>
>
> -----Original Message-----
> From: MS Excel General Q & A List
> [mailto:EXCEL-GPEACH.EASE.LSOFT.COM]On Behalf Of Vicki
Morrison
> Sent: Friday, May 26, 2006 10:10 AM
> To: EXCEL-GPEACH.EASE.LSOFT.COM
> Subject: How to delete duplicate rows
>
>
> I have searched the archives and found a message that
appears to answer =
> m=3D
> y=20
> question, but it isn't working. The archive message
says:
>
> 1) sort the list by the duplicated field(s)
>
> 2) create a equivalence check for the duplicated fields
in an adjacent =
> =3D
>
> column checking to see if the line above current line
is duplicated (the =
> =3D
>
> first line does not need to include this equivalence
check as since you =
> =3D
>
> sorted it is guaranteed to be the first occurrence
anyway). you should =
> us=3D
> e=20
> a equivalence check that returns something easy to
select, such as: =
> =3Dif=3D
>
> (a2=3Da1,"TRUE","") which will
produce a TRUE if equivalent and leave =
> bla=3D
> nk=20
> otherwise
>
> 3) highlight the entire column containing the
equivalency check and then
> select: edit>goto>special> and highlight
formulas and the logicals box =
> =3D
>
> only. this will select all TRUEs in your equivalence
check. then=20
> edit>delete>entire row.  goodbye duplicates.
>
> I made a column for the equivalence test and all the
duplicates say =
> "TRUE=3D
> "=20
> beside them, but when I highlight that column and then
try to=20
> select "Edit>Goto>Special and choose
Formulas and check the Logicals =
> box,=3D
>  I=20
> get a message that says "No cells were
found".=20
>
> I am using Excel 2003. Anyone know how to make this
work?
>
> Thanks,
> Vicki

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G