Hi
I am struggling to write a formulae that will give the value of the 2nd to last cell in a column that includes blank cells. I tried
=LOOKUP(2,2/(B1:B100>0),B5:B88)
However I think that is looking halfway down the column only. I just want the value of the 2nd to last cell with a value.
Any help would be appreciated.
;o)
Bookmarks