Address of the first empty cell in a column

In some cases it is useful to know the address of the first empty cell in a column. This is a way to do this without macros. Write the following formula and press CTRL+SHIFT+ENTER. Excel adds braces { } and saves it as array formula.

MATCH(TRUE,LEN(firstCell:lastCell)=0,0),1)),column number)

Example 1

First empty cell in column - example1



Example 2

First empty cell in column - example2

When (in which month) the division interrupted filling data? We are searching for the first blank cell in the column of division A, B, C and D. Formula for the Division A:


Note: Value #N/A means that there is no missing data.

And which cell is it?



Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress