Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare name lists
Okay, I have 2 lists of names (lname, fname separate cells) for staff with
software at different points in the year. I need to compare the lists and identify the differences. the catch is that lists come from different sources, so Mike could be Michael and Jeff could be Jeff K. (middle initial). I've gotten close a couple of times with some unique nested if's, match's, index's and left's, but haven't quite gotten it right. Any help? Here a sample of what data would look like. Thanks! Jones Bob Jones Robert Lind Mary Jones Michael Smith Joe K Smith Joe Young Bob Troy Mary |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare name lists
Hi:
Trying to match names is really quite difficult especially in your situation. The easy option is to request that they use employee numbers that would also remove the chance of two people with the same name. Other wise I would suggest you maintain an employee list and list each emplyee with the the possible options. You also get into problems with people with two first names such as 'Hans Peter' or double surnames as in 'Smith Brown'. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "deo89" wrote: Okay, I have 2 lists of names (lname, fname separate cells) for staff with software at different points in the year. I need to compare the lists and identify the differences. the catch is that lists come from different sources, so Mike could be Michael and Jeff could be Jeff K. (middle initial). I've gotten close a couple of times with some unique nested if's, match's, index's and left's, but haven't quite gotten it right. Any help? Here a sample of what data would look like. Thanks! Jones Bob Jones Robert Lind Mary Jones Michael Smith Joe K Smith Joe Young Bob Troy Mary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare lists | Excel Worksheet Functions | |||
Compare Two Lists | Excel Worksheet Functions | |||
Compare lists | Excel Worksheet Functions | |||
COMPARE 2 LISTS AND SEE COMBINED RESULTS BY CATEGORY | Excel Discussion (Misc queries) | |||
Excel - need a function to compare lists | Excel Worksheet Functions |