I have an Excel spreadsheet sorted alphabetically by last name with several columns among which are (not necessarily in this order): last_name, first_name, address, mailing_label_address. The mailing_label_address will be such that I can use it as an inserted field in a Word mail merge to create mailing labels.

Some of the people listed in the spreadsheet have the same address. As I want to send only one letter to that address, the mailing_label_address will have one of two forms. If the people with the same address have the same last name, e.g., a married couple, the mailing_label_address would look like this:

John and Mary Doe
5 Main St.
Victoria BC

If the people have different last names, the mailing_label_address would look like this:

John Doe
Mary Roe
5 Main St.
Victoria BC

This mailing address would appear in the mailing_label_address column for only one of the two people. It would be blank for the other person.

Is there a way to do this using Excel formulas or would a macro be needed? I do not do VBA programming, so if a macro is needed I would need someone on the forum to supply it.

Thanks for any help with this.
-- Art