Seems simple, but...Please Help!!!
 

I'm looking for a function that will return the value of the first non-blank
cell in a range.

Seems simple, but...Please Help!!!
 

Try...

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

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

On Nov 1, 3:11 pm, Bullseye
wrote:
I'm looking for a function that will return the value of the first non-blank
cell in a range.

Seems simple, but...Please Help!!!
 

Try this entered normally if TEXT
=INDEX(A2:A100,MATCH("*",A2:A100,0),0)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bullseye" wrote in message
...
I'm looking for a function that will return the value of the first
non-blank
cell in a range.

Seems simple, but...Please Help!!!
 

"Don Guillett" wrote...
Try this entered normally if TEXT
=INDEX(A2:A100,MATCH("*",A2:A100,0),0)
....

But if not text or not necessarily text, the following array formula
would find it.

=INDEX(A2:A100,MATCH(FALSE,ISBLANK(A2:A100),0))