Hi gurus!
Hope you are all well, I'm looking to help identifying levels from the CEO in data set, wondering if I could get some help on a formula I can use or what would be the best way to determine this without going manually. I've attached my sample data, I'm essentially trying to determine values in Column F (Levels from CEO)
CEO being 0 or CEO the top of the hierarchy, then their direct reports should be -1, then the direct reports of the CEO's direct reports would then be -2 and so on. If anyone can help me with this would be amazing!!!!!!!!!
View attachment Levels from CEO Sample.xlsx
Hope you are all well, I'm looking to help identifying levels from the CEO in data set, wondering if I could get some help on a formula I can use or what would be the best way to determine this without going manually. I've attached my sample data, I'm essentially trying to determine values in Column F (Levels from CEO)
CEO being 0 or CEO the top of the hierarchy, then their direct reports should be -1, then the direct reports of the CEO's direct reports would then be -2 and so on. If anyone can help me with this would be amazing!!!!!!!!!
View attachment Levels from CEO Sample.xlsx