I haven't been able to do this in Excel 97 or Excel 2000... Is it possible to use MATCH or another function to find the position of the first blank cell in a single-column range?
I want the formula to return 7 if A7 is the first empty cell in column A.
It is important that this works correctly, even if there are used cells below the first empty cell.
(I want a normal worksheet formula. NOT a VBA solution. NOT an array formula.)
This doesn't work (it returns #N/A!):