Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-13-2017, 09:50 AM
westendj westendj is offline Windows 7 64bit Office 2007
Novice
 
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
  #2  
Old 07-13-2017, 11:44 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,941
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Hi
please post a sample sheet with some (mock-up) data and expected results. Thx
Reply With Quote
Reply

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:52 AM.


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