Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding First Empty Cell in a Column
Hi,
Is there a formula method to find the first empty cell in a column? Thanks, Tom |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding First Empty Cell in a Column | Excel Discussion (Misc queries) | |||
Go to last non-empty cell in column | Excel Discussion (Misc queries) | |||
find first empty cell in column and start transpose next row in that cell | Excel Discussion (Misc queries) | |||
Using last cell in a column that is not empty in a calculation | Excel Worksheet Functions | |||
help locating first empty cell in a Column | Excel Worksheet Functions |