Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove duplicate records
I have a similar problem. I have records with duplicate information. I need
to condense the record, however, one cell in one column is different. I want to keep all of that cells information and remove the surrounding duplicate information. For example: Name Address Relatives Joe Smith 2145 Arts Way son Joe Smith 2145 Arts Way wife Joe Smith 2145 Arts Way daughter In this example, I want to condense to one line, his name, address and relatives. The remaining information, I want to delete it. Would a macro be best, and if so, what is the formula? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove duplicate records
Visit www.cpearson.com where Chip has lots of stuff on duplicates
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Valori" wrote in message ... I have a similar problem. I have records with duplicate information. I need to condense the record, however, one cell in one column is different. I want to keep all of that cells information and remove the surrounding duplicate information. For example: Name Address Relatives Joe Smith 2145 Arts Way son Joe Smith 2145 Arts Way wife Joe Smith 2145 Arts Way daughter In this example, I want to condense to one line, his name, address and relatives. The remaining information, I want to delete it. Would a macro be best, and if so, what is the formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i get rid of duplicate records in excel? | Excel Worksheet Functions | |||
how do I remove both duplicate records in excel | Excel Worksheet Functions | |||
remove duplicate records in Excel file | Excel Discussion (Misc queries) | |||
How to combine Excel 2002 files and remove duplicate records? | New Users to Excel | |||
How do I remove or filter out duplicate records in a sheet? | Excel Discussion (Misc queries) |