Hello all,
I'm having a hard time figuring out if this needs to incorporate a match function in there.
Essentially, what I'm trying to do is consolidate a formula that's in Column E all into Column D. Currently column E does it manually but I need to incorporate the lookup functionality into column D so it's all done there without having the luxury of changing what's in the Data tab or adding more columns to the Analysis tab.
Each Breakdown # is a group of jobs, and I want Column D to pull the sum of hours from the Data tab for that group of jobs at each line. I then want to divide this by the total hours in that whole initiative. In SQL teams, this would be a GROUP BY..
THANK YOU!!
Bookmarks