Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting specific records | Excel Discussion (Misc queries) | |||
Remove ALL duplicated records, leaving behind NONE | Excel Discussion (Misc queries) | |||
automatically delete records w/duplicate address in excel | Excel Discussion (Misc queries) | |||
Find & delete duplicated entries. | Excel Discussion (Misc queries) | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions |