Thread
:
Finding First Empty Cell in a Column
View Single Post
#
3
Posted to microsoft.public.excel.misc
Jacob Skaria
external usenet poster
Posts: 8,520
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
Reply With Quote
Jacob Skaria
View Public Profile
Find all posts by Jacob Skaria