Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identify the duplicate and delete with details in excel
Dear Friends,
I need to delete the company name which are dulpicate, alongwith its contact details. The data is in different row but all in 1 column. For Example in the below table, the col A14 has to be deleted with its contact details ie. col A15, A16, A17, A18, A19, A20 becuase it is a duplicate of Col A1 and necessary that Col A2,A3,A4.A5,A6,A7 are duplicate to A14 details. Hope i have not confused you. Column A 1.Company One 2.Address 1 3.Address 2 4.Address 3 5.Telephone: 6.Fax: 7.Website URL: 8.Company Two 9.Address 1 10.Address 2 11.Address 3 12.Telephone: 13.Fax: 14.Company One 15.Address 1 16.Address 2 17.Address 3 18.Telephone: 19.Fax: 20.Website URL: Regards Mat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can delete the duplicate word from a string in cell in EXCEL | Excel Discussion (Misc queries) | |||
How do I delete duplicate entries in excel? | New Users to Excel | |||
How do I delete duplicate records from an entire Excel workbook? | Excel Discussion (Misc queries) | |||
How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
How to delete duplicate rows in Excel 2000? | Excel Discussion (Misc queries) |