refering a blank cell

  • Thread starter Thread starter Edson
  • Start date Start date
E

Edson

Does anyone knows how can I refer the first blank cell in a column?
 
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
 
Thank you for replying my issue, Sebation
by the way, I was meaning to get the cell address.
it worked perfectly, thanks again
 
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

Averageifs - criteria is cell is not blank 1
balnk is no text or formula exist in reffering cell 3
Excel Concatenate with line breaks but ignore blank cells 3
Help needed 0
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Offset and Small functions with blank rows? 0
worksheet reference displays 0 on blank cell 2
Populate cell with multiple non-blank text values 3

Back
Top