How to delete duplicated records. Each record has four lines

G

Guest

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

Thanks.
 
E

Earl Kiosterud

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.
 
O

olasa

This is a simple way to find the duplicates:
=SUMPRODUCT(--((A1&CHAR(1)&A2&CHAR(1)&A3&CHAR(1)&A4)=($A$1:$A$200&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ö
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I remove all records of duplicated fields? 3
delete all dulplicate rows leaving no record of the duplicates 3
Merging Lines of data 4
Finding Unique records 3
How do I merge duplicated data in rows with different criteria 1
How do I eliminate duplicae records in excel file 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Duplicate Records 2

Top