| 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 | |||
Hybrid Mode
