?
Solved

Reverse Hierarchy

Posted on 2014-04-11
2
Medium Priority
?
201 Views
Last Modified: 2014-04-11
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
Comment
Question by:ablove3
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 23

Accepted Solution

by:
Ejgil Hedegaard earned 860 total points
ID: 39994427
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
 

Author Closing Comment

by:ablove3
ID: 39994693
That's an amazing formula.  It did exactly what I needed it to do.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question