Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an excel spreadsheet with the names of Companies in Column A and names
of Contacts in Column B, and additional contact information up to and including Column H . Can somebody give me a formula that will delete the entire row if the company and the contact name are the same (A=B) and they are in the spreadsheet more than once? Example: Col A Col B XYZ Company John Smith XYZ Company John Smith XYZ Company Jane Doe In this example, I would like Row 1 to be deleted, and rows 2 and 3 to be left in the database. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
delete duplicate record but only determine 1 column data | Excel Worksheet Functions | |||
Function to find duplicate values, then delete | Excel Worksheet Functions | |||
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) | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions |