Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-13-2017, 09:50 AM
westendj westendj is offline Need a formula to help track attendance Windows 7 64bit Need a formula to help track attendance Office 2007
Novice
Need a formula to help track attendance
 
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 Need a formula to help track attendance Windows 7 64bit Need a formula to help track attendance Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
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
Need a formula to help track attendance 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
Need a formula to help track attendance 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft