Array* formula for finding first blank cell in a range:
=ADDRESS(MIN(IF(ISBLANK(A1:A100),ROW(A1:A100),"x") ),COLUMN($A$1),4)

Adjust ranges as needed

*Use Ctrl+Shift+Enter to confirm array function
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"vinod" wrote:

ex
in column a
a1=1
a2=2
a3=3
a4=4
a5=blank

which formula for finding blank cell (a5)

thanks in advance