ExcelBanter - Look for the first non-blank cell above!

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Look for the first non-blank cell above! (https://www.excelbanter.com/excel-worksheet-functions/43182-look-first-non-blank-cell-above.html)

Tetsuya Oguma

Look for the first non-blank cell above!

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,
---
Tetsuya Oguma, Singapore

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)

"Tetsuya Oguma" wrote in message
...
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,
---
Tetsuya Oguma, Singapore

All times are GMT +1. The time now is 07:49 PM.