Monday, November 16, 2009

excel: how to find the first blank row/column

First blank column in the A row:
=MATCH(TRUE,ISBLANK(A2:AA2),0)


First blank row in the A column:
=MATCH(TRUE,ISBLANK(A2:A1000000),0)

No comments: