BleepingComputer.com: Work out next sequential date

I have used 'morefunc' addin to excel to use the following...

=LASTROW('sheet1'!A:A)

this shows the last row entry how do i find out the contents of the previous to last row?

This post has been edited by boopme: 16 July 2009 - 12:58 PM
Reason for edit: Moved to Business APPs ~~boopme

Use the Offset function from a known starting point.
Assume the last row# was 25. You want contents of A24.
'=offset(A25,-1,0) goes up one row and stays on the same column.
You just need to fit in your LastRow function into the offset() syntax.

Edit: I just realized you may need how to make an address from row and column numbers.
'=offset(address(lastrow(…),1),-1,0)
where in (...) just put what you now have, and 1 means columnA.

This post has been edited by tos226: 16 July 2009 - 09:58 PM