+ Reply to Thread
Results 1 to 7 of 7

Attendance list on a particular date

  1. #1
    Registered User
    Join Date
    03-01-2016
    Location
    Cluj-Napoca, Romania
    MS-Off Ver
    2016
    Posts
    3

    Attendance list on a particular date

    Hello,

    I have the following table:
    Name Dates
    Student1 2.2.2016 5.2.2016 18.2.2016
    Student2 5.2.2016 6.2.2016 8.2.2016 16.2.2016 29.2.2016
    Student3 4.2.2016 6.2.2016 16.2.2016 18.2.2016
    etc.

    I`m searching for a way to find who attended an a particular day i enter. for example:
    date i enter: 6.2.2016
    result generated:
    Student2
    Student3
    etc.

    Is it possible to do this in excel?

    Thank you

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,286

    Re: Attendance list on a particular date

    Here is a solution that uses the formula:
    Please Login or Register  to view this content.
    Here is a file with the formula applied: Attendance per Date.xlsx
    Notice that the dates must be formatted as dates.
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    03-01-2016
    Location
    Cluj-Napoca, Romania
    MS-Off Ver
    2016
    Posts
    3

    Re: Attendance list on a particular date

    Thank you for the quick reply. I`v already tried this way. My list consists of 80+ students. So in such a list, there are going to be alot of blank cells where students did not attend the class on a given date. Is there a way to have a clean column only with names? without formatting or sorting?

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,286

    Re: Attendance list on a particular date

    OK, then we can move the formula in post#2 over to column B and put the following array formula* in column A:
    Please Login or Register  to view this content.
    We could hide the names in column B by setting the font color to the same as the fill color.
    Here is a copy of your file that has the changes applied: Attendance per Date.xlsx
    Edit: *Array formulas are activated by pressing the Ctrl, Shift and Enter keys simultaneously.
    Let me know if you have any questions.
    Last edited by JeteMc; 03-01-2016 at 03:56 PM. Reason: Added edit

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,286

    Re: Attendance list on a particular date

    Deleted by JeteMc
    Last edited by JeteMc; 03-01-2016 at 12:29 PM. Reason: Duplicate

  6. #6
    Registered User
    Join Date
    03-01-2016
    Location
    Cluj-Napoca, Romania
    MS-Off Ver
    2016
    Posts
    3

    Re: Attendance list on a particular date

    that solves my problem! i`m not that familiar with array formula. I understand the logic but not always syntax.

    You sir are a live saver! wish you a awesome week

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,286

    Re: Attendance list on a particular date

    You're welcome and thank you for the feedback. I'd omitted the array formula warning, thank you for reminding me. If you haven't already, please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 03-17-2016, 05:34 AM
  2. [SOLVED] Searching for specific words in sheet for attendance list
    By Bossie94 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2015, 08:03 AM
  3. Need Help - AutoCalculate Attendance Points for employee attendance records
    By switzd0d in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-17-2015, 03:00 PM
  4. Problem excluding text inputs for an attendance list
    By hcaban in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2014, 10:48 AM
  5. Macro? To help generate a student attendance list......
    By LMM21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2012, 05:06 AM
  6. [SOLVED] Determine last date of attendance as we considered weekend, public holiday and absent date
    By ashburnadam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2012, 12:08 AM
  7. date of last attendance?
    By tannersnonni in forum Excel General
    Replies: 5
    Last Post: 07-27-2005, 10:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1