Ctrl+Shift+Enter
=INDEX(A1:A10,MATCH(TRUE,A1:A10="",0)-1,0)
DW wrote:
Thanks Peo, but, (and I probably didn't make myself clear, sorry),

let's say, A4 is first empty, how would I get the cell value of A3?

Hope this clears it up. Again, sorry.

Don

"Peo Sjoblom" wrote in message
...
=MATCH(TRUE,A1:A10="",0)

entered with ctrl + shift & enter will find the first and return the index
number so using A1:A10
and the first empty is in A4 it will return 4


--


Regards,


Peo Sjoblom


"DW" wrote in message
...
I believe there is a formula that has something about max(row, etc), but
cannot recall it.

Col A would contain a list of numbers.
I'm trying to find the first empty (blank) cell in col A.
Even tho I could write a macro to do this, I'm needing the cell formula.

Your help is greatly appreciated!!

Don