Finding First Empty Cell in a Column
 

Hi,

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

Thanks,

Tom

Finding First Empty Cell in a Column
 

The array formula:

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

should be entered with CNTRL-SHFT-ENTER rather than just the ENTER key.
--
Gary''s Student - gsnu200908


"TomHull" wrote:

Hi,

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

Thanks,

Tom

Finding First Empty Cell in a Column
 

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

If this post helps click Yes
---------------
Jacob Skaria


"TomHull" wrote:

Hi,

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

Thanks,

Tom

Finding First Empty Cell in a Column
 

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

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"TomHull" wrote:

Hi,

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

Thanks,

Tom

Finding First Empty Cell in a Column
 

Very nice
--
Gary''s Student - gsnu200908


"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"TomHull" wrote:

Hi,

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

Thanks,

Tom

Finding First Empty Cell in a Column
 

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
---------------
Jacob Skaria


"Gary''s Student" wrote:

Very nice
--
Gary''s Student - gsnu200908


"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"TomHull" wrote:

Hi,

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

Thanks,

Tom