Look for the first non-blank cell above!

T

Tetsuya Oguma

Hi all,

What would be the formula to locate the cell of the first non-blank cell
above?

I was playing with MATCH function but the first parameter doesn't take
zero-length string ("")!

Cheers,
 
B

Bob Phillips

Assuming the formula ism in F24, use

=MAX((OFFSET(F24,-1,0,-23,1)<>"")*ROW(OFFSET(F24,-ROW()+1,0,ROW()-1,1)))

as an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top