That's pretty interesting too. I will play around with this.

Thanks,
Paul

"T. Valko" wrote in message
...
If the position (address?) of the first non-blank is known then all you
need to do is start looking for the first non-blank after the known.

Based on your sample:

="A"&INDEX(ROW(A2:A20),MATCH("*",A2:A20,0))

Result = A6

Or is there more to it than that?

--
Biff
Microsoft Excel MVP


"PCLIVE" wrote in message
...
Given the position of a non-blank cell in a column, is there a way to
return the position of the next non-blank cell in the same column?

Example:
The given position of A1 is not blank. There is an unknown number of
consecutive spaces (blank cells) that follow in the same column. Is
there a formula that will tell me the position of the next non-blank
cell?

A
1 Test
2
3
4
5
6 UnknownData

The formula should be able to somehow return the row number or position
of the next non-blank cell, in this case would be row 6 or cell A6. Keep
in mind that the next value is unknown. Is this possible?

Thanks,
Paul