Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting Up a Series of Formulas
I have spread sheet from a mainframe download listing several thousand
employees of my company. I have three fields, [Employee Name] [Manager] [Job Description] that are of interest. The Job Description applies to the Employee not the manager, but the manager(s) is also an employee and appears in the Employee Name field. Job Desriptions are like, Manager of ......, Dir of......., Sr Dir of..... where the ....is "fill in the blank. I need to come up with a way to display the reporting order of each employee: [Name] [Manager] [Director] [Senior Director] [Vice President] John Sam Mary Phil Joe Helen Tom Paul Carol Jon Sam Mary Phil Joe Note that John reports to Sam, Sam reports to Mary and to display his reporting order, he will be in the Name field, not Manager field, since he is an employee as well as a manager Suggestions on how get this done is desparately needed. Thanks in advance Pepper |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA - Setting up a Chart series | Excel Discussion (Misc queries) | |||
Setting Excel chart series from vb6 | Charts and Charting in Excel | |||
off-setting points of different series b/c error bars overlap | Charts and Charting in Excel | |||
Problem setting up formulas | New Users to Excel | |||
Setting Series data in VBA | Charts and Charting in Excel |