Forum Discussion
Need Help with Logic on Employee Level
Hello, I am trying to understand how I can set Level of Heirarchy on a column where itis a list of employees from CEO to Associates. Associate Report to Managers Managers report to Leaders Lead...
For a technique that does not require helper columns (and can handle an arbitrary number of levels in the hierarchy), see the attached workbook.
Note: This uses the LAMBDA function, and thus requires Excel 365 or Excel for the web.