+ Reply to Thread
Results 1 to 2 of 2

Matching two employee directories, and adding the Employee #

  1. #1
    Registered User
    Join Date
    05-08-2015
    Location
    Middle of Nowhere
    MS-Off Ver
    2010
    Posts
    38

    Matching two employee directories, and adding the Employee #

    I have 2 sheets one has the Employee name and Employee # the Other only has the Employee name but it does not always match Ex. Jones, Tim and Jones, Timothy or Jordan, Michael and Jordan, P. Michael.

    How do I add the Employee #'s to the names that aren't exact.

    Sheet 1 has

    A, B, C,
    Name, Employee #, Company,
    Sheet 2 has

    A
    Name

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL (COVID allowing)
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,338

    Re: Matching two employee directories, and adding the Employee #

    Microsoft has produced a 'Fuzzy Lookup Add-In' which apparently deals with exactly this problem - Quote "For instance, it might detect that the rows “Mr. Andrew Hill”, “Hill, Andrew R.” and “Andy Hill” all refer to the same underlying entity, returning a similarity score along with each match."
    I haven't tried it myself so don't know if it's possible to put results into formulae from it, but you can find it here if you want to give it a try: http://www.microsoft.com/en-us/downl....aspx?id=15011

    Good luck.

    Regards,
    Aardigspook

    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
    You don't need to give me rep if I helped, but thanks are appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Generate output employee data from input employee sheet
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2015, 05:28 PM
  2. Employee hours - total for each employee
    By 1joie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-17-2014, 06:01 PM
  3. Employee ID matching
    By dsqboy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-27-2013, 08:51 AM
  4. [SOLVED] Calculate employee hours for employee evaluation?
    By Triesha in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2006, 10:55 AM
  5. [SOLVED] Return employee name when the employee's number is entered
    By Mike in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-16-2005, 03:05 PM
  6. Fromula to take employee # out of employee name field
    By mikeburg in forum Excel General
    Replies: 9
    Last Post: 09-11-2005, 11:05 PM
  7. Add Employee / Delete Employee Form questions
    By WinterCoast in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2005, 08:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1