Hmmm...

After reading the post again I don't think I follow the logic of the hierarchy.

I was thinking that all you needed to do was to find the bottom-most instance of the supervisor in column C then return all the employee numbers in column A from that row upwards.