Hi all,
I have a formula which returns the last/bottom value in a column (in this case column E on sheet 'Data Set'):
=LOOKUP(9.99999999999999E+307,'Data Set'!E:E)
Is it possible to have something to retrieve the value above it? (i.e. the last but one) - I thought I might be able to do it with OFFSETs but can't get it to work.
Thanks
Robert
Bookmarks