4 Replies Latest reply: Oct 31, 2017 7:55 AM by Mark Ritter RSS

    Data Matching

    Mark Ritter

      I have a situation where I have 2 excel files that I need to associate.

       

      Unfortunately the only common field between the 2 is the persons name.  Most of the names match between the 2 files.  However, I have situation where the person is a Jr. or Sr. and this only appears in one of the files.

       

      Is there a way that I can strip out the components of the name fields and then compare the parts that I know match?

      Or is there a fuzzy match function?

       

      I realize that even this could have issues.  But it is all that I have to work with. I just need to get as close as I can with what I have to work with.