First non empty cell and non blank cell
You're welcome!
--
Biff
Microsoft Excel MVP
"danpt" wrote in message
...
Thank you very much.
"T. Valko" wrote:
Since you're distinguishing empty from blank then I'm assuming you know
the
difference between the two. A cell can be blank but not empty. If the
first
non-empty cell contains a formula blank then the result of that formula
will
be the formula blank
Both formulas are array formulas**
For the first non-empty cell:
=INDEX(A1:A10,MATCH(1,SUBTOTAL(3,OFFSET(A1:A10,,,R OW(A1:A10)-MIN(ROW(A1))+1)),0))
For the first non-blank cell:
=INDEX(A1:A10,MATCH(TRUE,A1:A10<"",0))
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
--
Biff
Microsoft Excel MVP
"danpt" wrote in message
...
Can someone help me out with a formula that will return the value of
the
first non empty cell of a column.
And, also a formula that will return the value of the first non blank
cell
of a column.
Thank you
|