Finding First Empty Cell in a Column

T

TomHull

Hi,

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

Thanks,

Tom
 
G

Gary''s Student

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.
 
J

Jacob Skaria

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

If this post helps click Yes
 
G

Gary''s Student

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...
 
J

Jacob Skaria

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
 

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
First non empty cell and non blank cell 6
Find first empty cell in column 1
Find the first & subsequent cells to contain text in a column & re 28
how to know the active column is empty ? 3
If cell empty delete row 1

Top