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: 2,090
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
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
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 07:22 AM.


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