Hi,

The following array entered formula will do that

=INDEX(C3:C19,MATCH(TRUE,C3:C19<"",0))

Press Shift+Ctrl+Enter to enter it.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"FrankM" wrote:

I found this formula somewhere else on these boards ...


The VALUE of the last NON-BLANK cell in a COLUMN range
=LOOKUP(2,1/(A1:A100<""),A1:A100)

...

but what if I want to find the first non-blank vs the last non-blank?