Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Still needing help with last date attendend.. :(
I want to write a function which returns the last date a student attendend
class. Working from column IV backwards it would be the first cell in each row with hours recorded. The spreadsheet is setup like the following: X Y Z .........IV 29 Dates= 7/1 7/3 7/8 : LastDate* 33 Name1 7/3 3.2 2.5 34 Name2 7/8 1.5 4.5 Some tried to suggest to me using =INDIRECT(CHAR(LastDate(Row())+#)&"1"), but it doesn't work. Thanks in advance your help. -Stacy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Needing to know what formula to use | Excel Worksheet Functions | |||
needing a keystroke for the current date AND time | Excel Discussion (Misc queries) | |||
needing rtd assistance | Excel Discussion (Misc queries) | |||
Needing Help Very Bad | Excel Worksheet Functions | |||
Needing ideas on how to do this | Excel Programming |