Combine Last Names of Partners but only if different
I am trying to combine the last names of clients if they are related to each other. Some of my clients have different last names from their partner and I would like to be able to see that.
I am using one sheet as a database with the names. One column is the buyers last name and co buyer last name. How do I combine the two but only if the names are different.
Help Article Resources
Check out the Formula Handbook template!