Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help :Merge 2 employee information tables
I have 2 tables containing employee information. The names are in different
formats - 1st table has name in lname, fname and MI format whilest the other has either fname, lname or lname, fname or just lname. There is no employee number as a unique identifier. How am I going to merge these 2 tables Thanks akhilash |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help :Merge 2 employee information tables
ONly thing I can see is to add some helper columns to Table 1 by
concatinating from the lname, fname, MI format into the three options from Table 2, ie: fname, lname lname, fname lname and then use VLOOKUPS qualify each line of Table 2............. hth Vaya con Dios, Chuck, CABGx3 "akhilash" wrote: I have 2 tables containing employee information. The names are in different formats - 1st table has name in lname, fname and MI format whilest the other has either fname, lname or lname, fname or just lname. There is no employee number as a unique identifier. How am I going to merge these 2 tables Thanks akhilash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
joing (merge) tables by key field | Excel Worksheet Functions | |||
HOW TO MERGE TWO TABLES | Excel Worksheet Functions | |||
How do I merge excel information with a word document? | New Users to Excel | |||
Merge Pivot Tables | Excel Discussion (Misc queries) | |||
Referencing a newly created worksheet | Excel Worksheet Functions |