Hello,
I have a data set for my organization.
Column A, employee id
Column B, employee name
Column C, manager id
Columd D, manager name
this data goes all the way from bottom of org up to VP.
Example:
Empid Name manager id manager name
123. Bob Y 444. Rick
111 Jim Z Rick Y 444
222 Tim A Rick Y 444
444 Rick Y Tessa A 555
555 Tessa A Mary B 888
666 Dru F Mary B 888
777 John Q Mike A 999
I'd like to know if there is a way using formulas to get a report that would give me all of the people that report under a certain individual including the indirect reports. So if I was to select a director, it would give me all managers, supervisors, leads, etc... under that director. so in the case above, if I picked Mike A I would get back John Q but if I Picked Mary B, Id get back everyone else.
I've looked for a few hrs in the forum and not sure this has been asked before.
just need a list of names.
any suggetsions? I'd prefer formulas to do this as I'm not that great in VB.?
I have a data set for my organization.
Column A, employee id
Column B, employee name
Column C, manager id
Columd D, manager name
this data goes all the way from bottom of org up to VP.
Example:
Empid Name manager id manager name
123. Bob Y 444. Rick
111 Jim Z Rick Y 444
222 Tim A Rick Y 444
444 Rick Y Tessa A 555
555 Tessa A Mary B 888
666 Dru F Mary B 888
777 John Q Mike A 999
I'd like to know if there is a way using formulas to get a report that would give me all of the people that report under a certain individual including the indirect reports. So if I was to select a director, it would give me all managers, supervisors, leads, etc... under that director. so in the case above, if I picked Mike A I would get back John Q but if I Picked Mary B, Id get back everyone else.
I've looked for a few hrs in the forum and not sure this has been asked before.
just need a list of names.
any suggetsions? I'd prefer formulas to do this as I'm not that great in VB.?
