• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Eliminate Duplicates and Total Other Data Associated

M

mrsjbw

New Member
I've created a Project Management Resource Log in which we ask each employee to list their weekly activities, the activity's start and end dates, assign an "effort" level to the activity (1 thru 3), and choose from a list of pre-defined projects the activities are performed for. This makes for a LONG list and I'd like to consolidate the data by Project Name and and then the total effort level associated with that project. Each person has their own spreadsheet to enter data. After I've figured out how to do this... I will make a Gantt chart out of the data. Any advice, I'm a novice and stuck.


THANKS!
 
You may consolidate all raw data sheets into one single rawdata sheet and then use Pivot table to get the desired output.


http://chandoo.org/wp/2010/02/19/excel-consolidate-data/


~VijaySharma
 
You must log in or register to reply here.
Back
Top