# Thread: last not- 'blank' row? (2k but prob all)

1. ## last not- 'blank' row? (2k but prob all)

I8:I13 contain formulae of the type (in I9)
=IF(E9="","",I8-E9+F9)
(that in I8 refers to an absolute reference elsewhere)
What formula can I put in eg F19 which will return the value of the last not-blank cell in the range I8:I13?
Nested IFs I suppose will do it, but are very ugly and hard to follow. And can't be extended if the range grows to >9 rows, I think.
MAX or MIN won't do, as non-blank values won't necessarily follow a pattern.

3. ## Re: last not- 'blank' row? (2k but prob all)

Thanks, John, Steve's formula involving the jumbo-sized number does the trick for me.
(Quite why and how defeats me at present!)

4. ## Re: last not- 'blank' row? (2k but prob all)

It returns the content of the highest row with something numeric:

=VLOOKUP(65536,I:I,1)

will do the same (until there's a version of Excel with more rows).

5. ## Re: last not- 'blank' row? (2k but prob all)

Yes, I'd figured that's how it worked, and figured equally that the formula as offered contained a Pittsburgh Wind-Up.
But thanks, still.