Hi All - any help with this issue would be greatly appreciated.
I have a sheet where I make work assignments (including budgeted hours) to each employee by task by day. There can be multiple assignments and employees on any given day. The sheet outlines all assignments for a year and looks something like this:
<tbody>
</tbody>
I then want a summary sheet where I can see the total hours assigned to an employee on any given day. It would look something like this (ideally in the format below so I can filter).
<tbody>
</tbody>
I realize that I can use Hlookup an manually change the array for each day since all the dates in a year is a finite group. However I was hoping for something more formula driven? Thanks in advance for you suggestions.
I have a sheet where I make work assignments (including budgeted hours) to each employee by task by day. There can be multiple assignments and employees on any given day. The sheet outlines all assignments for a year and looks something like this:
Task | Employee | 1/1/19 | 1/2/19 | 1/3/19 |
A | Sarah | 5 | 5 | 5 |
B | Justin | 2 | 2 | 2 |
C | Sarah | 3 | 3 | 3 |
D | Bruce | 1 | 2 | 3 |
E | Justin | 4 | 4 | 4 |
<tbody>
</tbody>
I then want a summary sheet where I can see the total hours assigned to an employee on any given day. It would look something like this (ideally in the format below so I can filter).
Date | Sarah | Justin | Bruce |
1/1/19 | 8 | 6 | 1 |
1/2/19 | 8 | 6 | 2 |
1/3/19 | 8 | 6 | 3 |
<tbody>
</tbody>
I realize that I can use Hlookup an manually change the array for each day since all the dates in a year is a finite group. However I was hoping for something more formula driven? Thanks in advance for you suggestions.