Finding First Empty Cell in a Column

[TomHull]

Hi,

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

Thanks,

Tom

 

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

 

[Jacob Skaria]

Try
=SUMPRODUCT(MATCH("",A1:A100&"",0))

If this post helps click Yes

 

[Jacob Skaria]

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

If this post helps click Yes

 

[Gary''s Student]

Very nice
--
Gary''s Student - gsnu200908

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

If this post helps click Yes

 

[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