Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • Last Modified:

Reverse Hierarchy

Hello,

I created a natural hierarchy based off of an employee and supevisor ID.  The hierachy rolls all the way up to the highest level (see columns L - S).

How could I create a hierachy that would roll from the highest position to the lowest level manager (see columns U - AA)
Reverse-Hierarchy.xlsx
0
ablove3
Asked:
ablove3
1 Solution
 
Ejgil HedegaardCommented:
Use this formula in AD4

=IF(8-COUNTIF($L4:$S4,"")-COLUMN()+COLUMN($AD$3)>0,INDEX($L4:$S4,1,8-COUNTIF($L4:$S4,"")-COLUMN()+COLUMN($AD$3)),"")

Open in new window


Copy across and down
0
 
ablove3Author Commented:
That's an amazing formula.  It did exactly what I needed it to do.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now