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
|