Range and dates
I am trying to keep track of attendance. I want to be able to retrieve dates
of when a student is absent. How can I do that? "Student I.D. #" Last Name First Name 12/1/05 12/2/05 12/3/05 12/04/05 Student Example Absent Absent When I do my report, I want to be able to get the date the student was absent. I need help on my formula. |
Range and dates
Last date?
Just use =INDEX(1:1,MATCH(9.99999999999999E+307,2:2)) assuming the data is in row 2, dates in row 1. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Mike" wrote in message ... I am trying to keep track of attendance. I want to be able to retrieve dates of when a student is absent. How can I do that? "Student I.D. #" Last Name First Name 12/1/05 12/2/05 12/3/05 12/04/05 Student Example Absent Absent When I do my report, I want to be able to get the date the student was absent. I need help on my formula. |
All times are GMT +1. The time now is 01:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com