#1
|
|||
|
|||
Need a formula to help track attendance
I'm looking to identify people who haven't been in attendance for X number of times.
I have a simple table with last names in A and first names in B. Row 1 has dates listed by mm/dd. When someone is in attendance, I place in "x" in that cell. What I would like is to track who has missed the last three times. In other words I need something that can search the table beginning with the correct/current date column, count back three columns and make a list of every name that has no "x" in any of the three cells. Is this possible? Would there be a better way to track attendance that would allow such a function? |
#2
|
||||
|
||||
Hi
please post a sample sheet with some (mock-up) data and expected results. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Attendance Analysis | LarryLee87 | Excel Programming | 4 | 11-23-2016 05:14 PM |
office template: employee attendance tracker | LeylandRick | Excel | 2 | 01-08-2016 03:35 AM |
Export meeting attendance to .csv/Excel | danieljoachim | Outlook | 0 | 02-05-2015 06:44 AM |
Track Changes doesn't track Change Case changes | wardw | Word | 3 | 10-28-2012 05:31 PM |
Automate Office Attendance | kgwack | Outlook | 0 | 02-14-2012 09:39 AM |