Finding First Empty Cell in a Column

  • Thread starter Thread starter TomHull
  • Start date Start date
T

TomHull

Hi,

Is there a formula method to find the first empty cell in a column?

Thanks,

Tom
 
The array formula:

=ADDRESS(MIN((IF(ISBLANK(A1:A99),ROW(A1:A99)))),COLUMN(A:A))

should be entered with CNTRL-SHFT-ENTER rather than just the ENTER key.
 
Try
=SUMPRODUCT(MATCH("",A1:A100&"",0))

If this post helps click Yes
 
For cell address..(normal entered)
=ADDRESS(SUMPRODUCT(MATCH("",A1:A100&"",0)),COLUMN(A1:A100))

If this post helps click Yes
 
Very nice
--
Gary''s Student - gsnu200908


Jacob Skaria said:
For cell address..(normal entered)
=ADDRESS(SUMPRODUCT(MATCH("",A1:A100&"",0)),COLUMN(A1:A100))

If this post helps click Yes
Click to expand...
 
Thanks. Could be even the below which is a bit more easy to understand..

=SUMPRODUCT(MATCH(TRUE,A1:A100="",0))

If this post helps click Yes
 
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

Find first empty cell in column 2
Find the first cell to contain text in a column 7
first empty value 1
VBA set thick borders around non empty cells in range 0
how do I average a range which also contains empty cells 2
Find first empty cell in column 1
First non empty cell and non blank cell 6
Find the first & subsequent cells to contain text in a column & re 28

Back
Top