| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help! how to cross - data with excel??
Hi, I'm required to present some info at my work, using two excel files. This
is the task: File 1, has ID numbers in column A, and column B is blank. File 2, has ID numbers in column C and column D has the date the person joined the company File 1 es a select grop of people (about 2500), whereas File 2 is the general database (about 30thou) They're asking me to match the data, in order to end up with the coresponding date they joined the company in column B on File 1 (obtained from column D on file 2), how to do it? taking in account that File 1 is outdated and some people might not be in file 2. I would really appreciate any help you might give me. Gloria |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cross referencing data | Excel Discussion (Misc queries) | |||
| How to cross-multiply text data in excel?? | Excel Discussion (Misc queries) | |||
| Cross-Referencing Data | Excel Discussion (Misc queries) | |||
| Capture cross-section data | Excel Discussion (Misc queries) | |||
| cross referenceing data in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
