I'm not proficient in macros, so I was looking for a function that will look
for duplicates and mark one of them so I can delete it but then put in the
combined mail name.

My data looks like this:
ConsID CombinedName AddrName Final Mailing Name
01234 Mr. and Mrs. Joe Smith Mr. Joe Smith Mr. Joe Smith
01243 Mr. and Mrs. Joe Smith Mrs. Joe Smith delete
01235 Mrs. Henry Doe Mrs. Henry Doe

When I combine Mr. Joe Smith and Mrs. Joe Smith, I want the Final Mailing
Name to read Mr. and Mrs. Joe Smith because it will be going to both of them.

The final result would be:
ConsID CombinedName AddrName Final Mailing Name
01234 Mr. and Mrs. Joe Smith Mr. Joe Smith Mr. and Mrs. Joe Smith
01243 Mr. and Mrs. Joe Smith Mrs. Joe Smith delete
01235 Mrs. Henry Doe Mrs. Henry Doe

I've been using
=if (A2=B2, "Delete","")
but I can't figure out how to pull the combined name into another column?

Thanks- I hope this makes sense.