Hello,

I have a data set for my organization.
Column A, employee #
Column B, name
Column C, Supervisor

this data goes all the way from bottom of org up to VP.

Example:
Emp# Name Supervisor
123 Bob Y Rick Y
111 Jim Z Rick Y
222 Tim A Rick Y
444 Rick Y Tessa A
555 Tessa A Mary B
666 Dru F Mary B
777 John Q Mike A

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.
The data doesnt need to be ordered, but just need a list of names.
any suggetsions? or does this have to be done with VB?

Thanks for your help!!!


Carlos