I am trying to develop an organization structure, but data comes in awkward. I also want to roll up each cost center to the appropriate Managing Director and VP, but I just cannot figure out a good formula. Can anyone help? Attached is an example of the data I am looking at
You will not be able to do that with formulas.
Let say in row 10 you have got
Casey Locke Garry Williams,
This is not reflected on your outcome
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks