Index/Match or Something Else
I have a worksheet that will look something like this:
Last NameWorked DepartmentHoursEmployee 1Project 72Employee 1Project 43Employee 1Project 51Employee 1Project 22Employee 1Project 41.5Employee 1Project 12Employee 1Project 22Employee 1Project 31Employee 1Project 101.5Employee 1Project 103Employee 1Project 42Employee 2Project 52Employee 2Project 41Employee 2Project 12Employee 2Project 33Employee 2Project 22Employee 2Project 41Employee 2Project 43Employee 2Project 22Employee 2Project 31Employee 2Project 32Employee 2Project 78Employee 3Project 51.5Employee 3Project 52.5Employee 3Project 52Employee 3Project 11Employee 3Project 41Employee 3Project 31.5Employee 3Project 42.5Employee 3Project 42
This worksheet will show the hours worked for thirty employees by Project worked.
I will be creating another worksheet that will look something like this:
Employee 1Employee 2Employee 3TotalsProject 1 – Project 2 Project 3 – Project 4 – Project 5 – Project 6 – Project 7 – Project 8 – Project 9 – Project 10 –
I want to write formulas in this worksheet such that it will look at the first worksheet and populate the second worksheet with the hours charged by employee to each of the projects. In this case the final work sheet would look like this:
Employee 1Employee 2Employee 3TotalsProject 1 2.00 2.00 2.00 6.00Project 2 4.00 4.00 Project 3 1.00 6.00 2.50 9.50Project 4 6.50 5.00 5.50 17.00Project 5 1.00 2.00 6.00 9.00Project 6 – – – – Project 7 2.00 8.00 – 10.00Project 8 – – – – Project 9 – – – – Project 10 – – – –
I believe that a pivot table could be used but I need to do additional calculations using this data that would not work in a pivot table. The second worksheet will be a template for future months use.
I would appreciate any help/suggestions.
I have a worksheet that will look something like this:Last NameWorked DepartmentHoursEmployee 1Project 72Employee 1Project 43Employee 1Project 51Employee 1Project 22Employee 1Project 41.5Employee 1Project 12Employee 1Project 22Employee 1Project 31Employee 1Project 101.5Employee 1Project 103Employee 1Project 42Employee 2Project 52Employee 2Project 41Employee 2Project 12Employee 2Project 33Employee 2Project 22Employee 2Project 41Employee 2Project 43Employee 2Project 22Employee 2Project 31Employee 2Project 32Employee 2Project 78Employee 3Project 51.5Employee 3Project 52.5Employee 3Project 52Employee 3Project 11Employee 3Project 41Employee 3Project 31.5Employee 3Project 42.5Employee 3Project 42 This worksheet will show the hours worked for thirty employees by Project worked. I will be creating another worksheet that will look something like this: Employee 1Employee 2Employee 3TotalsProject 1 – Project 2 Project 3 – Project 4 – Project 5 – Project 6 – Project 7 – Project 8 – Project 9 – Project 10 – I want to write formulas in this worksheet such that it will look at the first worksheet and populate the second worksheet with the hours charged by employee to each of the projects. In this case the final work sheet would look like this: Employee 1Employee 2Employee 3TotalsProject 1 2.00 2.00 2.00 6.00Project 2 4.00 4.00 Project 3 1.00 6.00 2.50 9.50Project 4 6.50 5.00 5.50 17.00Project 5 1.00 2.00 6.00 9.00Project 6 – – – – Project 7 2.00 8.00 – 10.00Project 8 – – – – Project 9 – – – – Project 10 – – – – I believe that a pivot table could be used but I need to do additional calculations using this data that would not work in a pivot table. The second worksheet will be a template for future months use. I would appreciate any help/suggestions. Read More