Hi Dudes,

Can anyone help with this problem:

I've got a list of data as such

34
54
23
34
blank
77
45
67
45
blank


To get the last non-blank cell value I'm using =LOOKUP(1E+40,A1:A10).

Anyone know a formula of how to look up the 2nd last value.


--
geoff1234
------------------------------------------------------------------------
geoff1234's Profile: http://www.excelforum.com/member.php...o&userid=36051
View this thread: http://www.excelforum.com/showthread...hreadid=559340