Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 07-13-2017, 09:50 AM
westendj westendj is offline Windows 7 64bit Office 2007
Join Date: Jul 2017
Posts: 1
westendj is on a distinguished road
Default 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?
Reply With Quote
Old 07-13-2017, 11:44 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,292
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light

please post a sample sheet with some (mock-up) data and expected results. Thx
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote

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

All times are GMT -7. The time now is 11:05 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft