how to find blank cell in column

  • Thread starter Thread starter vinod
  • Start date Start date
V

vinod

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

which formula for finding blank cell (a5)

thanks in advance
 
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
 
Back
Top