ExcelBanter - Find first empty cell in column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Find first empty cell in column (https://www.excelbanter.com/excel-discussion-misc-queries/247910-find-first-empty-cell-column.html)

TomHull

Find first empty cell in column

hi,

Dos anyone know if there is a formula method for returning the cell
reference of the first cell in a column that is blank?

Cheers.

Jacob Skaria

Find first empty cell in column

Check your previous post..

=SUMPRODUCT(MATCH(TRUE,A1:A100="",0))

If this post helps click Yes
---------------
Jacob Skaria

"TomHull" wrote:

hi,

Dos anyone know if there is a formula method for returning the cell
reference of the first cell in a column that is blank?

Cheers.

All times are GMT +1. The time now is 09:23 AM.