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

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

Guest

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

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

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

Hope this helps!
 
Try this entered normally if TEXT
=INDEX(A2:A100,MATCH("*",A2:A100,0),0)
 
Don Guillett said:
Try this entered normally if TEXT
=INDEX(A2:A100,MATCH("*",A2:A100,0),0)
Click to expand...
....

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

=INDEX(A2:A100,MATCH(FALSE,ISBLANK(A2:A100),0))
 
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

Set non-continuous PrintArea via Function / Name 0
Excel Concatenate with line breaks but ignore blank cells 3
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Finding the position of the i-th non blank cell in a vertical range 6
Search for specific text within last non blank cell in a range 2
find last populated cell in range of cells 6
row number of last non-blank cell 14
VBA set thick borders around non empty cells in range 0

Back
Top