ExcelBanter

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 November 9th 09 05:06 AM

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 November 9th 09 05:16 AM

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:01 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com