How to delete duplicated records. Each record has four lines
 

I would like to delete duplicated records from an excel file. Each record has
four lines.

Thanks.

Arcesio,

You'll find that none of Excel's tools (Sort, Pivot Tables, Database
functions, Subtotals, Charts, Autofilter, Advanced filter, Data form, to
name a few), work with multiline records. I think you should look strongly
at converting your data to a bona fide database-style table. It will open
up all kinds of Excel functionality.
--
Earl Kiosterud
www.smokeylake.com

"Arcesio Hernandez" <Arcesio wrote in
message ...
I would like to delete duplicated records from an excel file. Each record
has
four lines.

Thanks.

This is a simple way to find the duplicates:
=SUMPRODUCT(--((A1&CHAR(1)&A2&CHAR(1)&A3&CHAR(1)&A4)=($A$1:$A$20 0&CHAR(1)&$A$2:$A$201&CHAR(1)&$A$3:$A$202&CHAR(1)& $A$4:$A$203)))1

The formula concatenate 4 rows and tries to find a match.
CHAR(1) prevents Errors like ABCD&""&""&""=A&B&C&D

HIH
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390369