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,147
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice

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)
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 06:06 AM.

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