how to find blank cell in column

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
 
L

Luke M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Leaving a cell blank 5
Average Question 2
Conditional Printing 2
Give blank in cell 2
simple: Identify a cell that is out of number sequence in a list 10
Sum number range ignoring numbers formatted as text 0
Need a UDF to count blank cells 5

Top