Ben_Hansel, I think you misunderstand me. I am consolidating entries with the same mailing address, not same last name.
Merge Example.xlsx
Here is an example of what it is I'm looking to do. I know It would still require some manual checking on my part, but something to do this automatically would cut the time I spend on these list in the office in half.