I think this would be a COUNTIF combined with a INDEX MATCH MATCH.
-1 book
-2 worksheets
Input sheet from Call Report (this is counting attendance for conference call)
<tbody>
</tbody>
What I want it to auto populate
<tbody>
</tbody>
There may be a template for this already, but basically there is a list that is populated each day of the people in attendance. A VLOOKUP or lookup of some sort would look for the EMP # for each day and then input a 1. This would make for the ability to find a percentage of attendance.
Any help would be helpful.
-1 book
-2 worksheets
Input sheet from Call Report (this is counting attendance for conference call)
DATE | PERSON ID |
4-14 | 1 |
4-14 | 2 |
4-16 | 1 |
4-16 | 3 |
<tbody>
</tbody>
What I want it to auto populate
Date | Emp 1 | Emp2 | Emp 3 | Emp 4 | Emp5 |
4-14 | 1 | 1 | |||
4-15 | |||||
4-16 | 1 | 1 | |||
4-17 |
<tbody>
</tbody>
There may be a template for this already, but basically there is a list that is populated each day of the people in attendance. A VLOOKUP or lookup of some sort would look for the EMP # for each day and then input a 1. This would make for the ability to find a percentage of attendance.
Any help would be helpful.