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
|