Results 1 to 2 of 2

Thread: Count Attendance for People On Certain Dates

  1. #1
    New Member
    Join Date
    Nov 2017
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Cool Count Attendance for People On Certain Dates

    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


    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









    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.

  2. #2
    Board Regular
    Join Date
    Nov 2005
    Location
    Clearwater, Florida
    Posts
    1,187
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Count Attendance for People On Certain Dates

    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.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •