Look for the first non-blank cell above!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First Non-Blank Cell 6
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
How to count the maximum number flanked by zeros 9
Counting blank cells between non-blank cells 4
Ref of First Non blank cell 7
#value error for sumproduct using RIGHT cmd 0
Last "non-blank" value in a Row... 2
Reference to next non-blank cell 5

Back
Top