Formula to Return cell adress for next non-blank cell in a range

I need a formula to find the Cell Address after the first non blank cell in a column of text values that has blanks in it?

Try ...

="A"&MIN(IF((A1:A100="")*(A2:A101<>""),ROW(A2:A101),""))

Enter with Ctrl+Shift+Enter.

Maybe this...

Data Range

	A	B
1	Header	A7
2	data	------
3
4
5
6
7	data
8	data
9
10	data

This array formula** entered in B1:

=ADDRESS(SMALL(IF(A2:A10<>"",ROW(A2:A10)),2),1,4)

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

You're welcome!