| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
date of last attendance?
I have an attendance spreadsheet. I am not really great at excel :(!
I need to show the last date they entered attendance by posting a P for present in the column set for the specific date. Names of Students in Col A9:B100 Dates of Classes in Row D7 to BC7 (this is formated as a simple number so I can count the number of total times attended - it was the only way I could figure it out) The student enters a "P" in the column below the date in the row with their name. I need to know at any given time which was the last date they entered a "P". I have tried many ways to look this up here and can't find it. I will appreciate any help anyone can give me. Please give complete intructions as I don't understand code very well. I am pretty good at functions. Thanks everyone! maureen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| Date Math Problem | Excel Worksheet Functions | |||
| date and time | New Users to Excel | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Threaded Mode
