keenercoug
New Member
- Joined
- Aug 12, 2010
- Messages
- 2
I currently have a spreadsheet in which i enter in data everyday. At the "bottom" of the info I have a summary row. When I input data daily the days are listed by row (eg row 42 = March 1st, row 41 = march 2nd), I am looking for is a formula to grab whatever is the top or "most recent" day. I currently use this formula:
=INDEX(F12:F42,MATCH(TRUE,INDEX(F12:F42<>0,0,0),0))
It works fine however, I have some folks that use OpenOffice and these formulas do not translate correctly. I have read that OpenOffice is more exact, for lack of better term, in its use of formulas. I was hoping anyone might have another idea how to collect this data. I appreciate any help you can give.
Thanks
z
=INDEX(F12:F42,MATCH(TRUE,INDEX(F12:F42<>0,0,0),0))
It works fine however, I have some folks that use OpenOffice and these formulas do not translate correctly. I have read that OpenOffice is more exact, for lack of better term, in its use of formulas. I was hoping anyone might have another idea how to collect this data. I appreciate any help you can give.
Thanks
z