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