E
Edson
Does anyone knows how can I refer the first blank cell in a column?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
formula or macro?
E
Edson
Hi Don,
I need a formula, if is possible.
TIA
Edson
I need a formula, if is possible.
TIA
Edson
S
Sebation.G
i am not quite sure what your refer means?
guess u want get the first blank row,u can use the array formula like this
=MATCH(TRUE,ISBLANK(A$1:A$18),0) then hit CSE(ctrl+shift+enter)
while get the address,u can use
=ADDRESS(MATCH(TRUE,ISBLANK(A$1:A$18),0),A:A) then hit CSE
Hope this can be helpful
Regards,
Sebation.G UK
guess u want get the first blank row,u can use the array formula like this
=MATCH(TRUE,ISBLANK(A$1:A$18),0) then hit CSE(ctrl+shift+enter)
while get the address,u can use
=ADDRESS(MATCH(TRUE,ISBLANK(A$1:A$18),0),A:A) then hit CSE
Hope this can be helpful
Regards,
Sebation.G UK
E
Edson
Thank you for replying my issue, Sebation
by the way, I was meaning to get the cell address.
it worked perfectly, thanks again
by the way, I was meaning to get the cell address.
it worked perfectly, thanks again