Hi
I've a database which has headcount names with unique employee ID, also have their direct Managers' employee ID. I wish to calculate number of Layers for each employee. I've attached example of the dataset, on which I wish to do this. Any help, guidance will be very much appreciated.
Many Thanks
Rahul
Hello rahulismyname and Welcome to Excel Forum.
This proposal employs helper columns which may be moved and/or hidden for aesthetic purposes.
The first helper column is populated using: =COUNTIFS(D$2:D$26,B2)
The second and subsequent helper columns are populated using: =COUNTIFS(F$2:F$26,">0",$C$2:$C$26,"<>"&"-",$D$2:$D$26,$B2)
The "Layers" column is populated using: =COUNTIFS(F2:H2,">0")
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks