HI! I'm trying to create a project timeline in an ongoing database. The attached file has 2 tabs, data and summary.
The "data" tab has project phases going across columns and project manager names going down rows.
The "summary" tab has the timeline info as to who is doing what phase in which month.
I'm having a hard time getting it right. I thought pivot table would help but can't get all the data on the pivot table.
In "summary" tab cell $c$3 is a formula which I wrote which does the job right as the result in that cell is 1. But I need help when the result is more than 1 like in $g$4 of the "summary" tab.
Have a project deadline, any help will be appreciated.
Thanks,
Kavir