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)

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD="align: center"]DATE[/TD]
[TD]PERSON ID[/TD]
[/TR]
[TR]
[TD]4-14
[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4-14[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4-16[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4-16[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]


What I want it to auto populate

[TABLE="class: outer_border, width: 500, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Emp 1[/TD]
[TD]Emp2[/TD]
[TD]Emp 3[/TD]
[TD]Emp 4[/TD]
[TD]Emp5[/TD]
[/TR]
[TR]
[TD]4-14[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4-15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4-16[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4-17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]









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.