• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to find first empty cell

M

mandarp22

Member
How to find first empty cell in a range of cells in a column from the bottom with the help of formula

Please help!

Col A

20


12

29


24

38

<= A8 this is the ans

28

10


Regards

mandar
 
Mandar


An array formula will tell you what Row it is in:


Code: 
=MAX(IF(A1:A10="",ROW(A1:A10))) [b] Ctrl + Shift + Enter


If you really need the Column


="A"&MAX(IF(A1:A10="",ROW(A1:A10)))
Ctrl + Shift + Enter[/b]
 
Hi all

I think earlier in this post I have described my problem wrongly though the formula given buy Hui works great but my need is different. I want to use values from the column A in the same row where there is blank cell in column B


Col A Col B

1000 2

2000 4

1000

2000 5

3000 3

4000 <= (Col A 4000 is the ans i need to use that cell value in other formula)

2000 5

3000 7

1000 6
 
Combine Hui's formula with an INDEX:

=INDEX(A:A,MAX(IF(B1:B10="",ROW(B1:B10))))
 
You must log in or register to reply here.
Back
Top