Count Attendance for People On Certain Dates

[wmunsey81]

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)

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.

 

[Joyner]

Hello , the easiest way to get the report you are looking for in to use a Pivot Table.

Date to rows, Employee number to columns and also to values area, if employee "number" is actually text you are done. If employee number is actually a number then change the value to count instead of sum.