Finding First Empty Cell in a Column

T

TomHull

Hi,

Is there a formula method to find the first empty cell in a column?

Thanks,

Tom
 
G

Gary''s Student

The array formula:

=ADDRESS(MIN((IF(ISBLANK(A1:A99),ROW(A1:A99)))),COLUMN(A:A))

should be entered with CNTRL-SHFT-ENTER rather than just the ENTER key.
 
J

Jacob Skaria

For cell address..(normal entered)
=ADDRESS(SUMPRODUCT(MATCH("",A1:A100&"",0)),COLUMN(A1:A100))

If this post helps click Yes
 
G

Gary''s Student

Very nice
--
Gary''s Student - gsnu200908


Jacob Skaria said:
For cell address..(normal entered)
=ADDRESS(SUMPRODUCT(MATCH("",A1:A100&"",0)),COLUMN(A1:A100))

If this post helps click Yes
Click to expand...
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Find first empty cell in column 2
Cumulative formula for word table 0
Huge msp file 0
Copy addition formula of non-consecutive horizontal cells 2
Turning off automatic calculation 0
Export BPMN Visio Chart to Excel 0
Shared Link is showing empty notebook 1

Top