Hi!

Try this entered as an array using the key combination of CTRL,SHIFT,ENTER:

=INDEX(A1:A100,MATCH(TRUE,A1:A100<"",0))

Biff

"igbert" wrote in message
...
Hi,

Ias there a similar formula to find the first non blank cell in a range?


Igbert


"starguy" wrote:


try this?

=LOOKUP(2,1/(range<""),range)


--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread:
http://www.excelforum.com/showthread...hreadid=534500