G
Guest
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
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