Finding first non-empty cell in a column

[David Morrison]

I have a column which has a lot of empty cells. I want to find the first
cell which has a value in it. Is there any way to do this?

Next question: Is there a way to find the second, third, etc cells,
given that there may be empty cells in between.

Thanks

 

[CyberTaz]

Hi David -

I'm afraid I'm not really clear on what you're looking to do - especially re
your "next question". Can you elaborate a bit more?

In the mean time perhaps Cmd+DownArrow will help. If you are in an empty
cell it will take you to the first cell in the column that has content. If
you start in a cell that does have content it will take you to the last
consecutively filled cell in the column (the cell that precedes the next
empty cell).

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[David Morrison]

Hi David -

I'm afraid I'm not really clear on what you're looking to do - especially re
your "next question". Can you elaborate a bit more?

In the mean time perhaps Cmd+DownArrow will help. If you are in an empty
cell it will take you to the first cell in the column that has content. If
you start in a cell that does have content it will take you to the last
consecutively filled cell in the column (the cell that precedes the next
empty cell).

I want to use it in a formula. So I have a column which is mostly blank
cells, and I want to set another cell to the value of the first
non-blank one.

That's my requirement atm, but I wondered whether it was possible to
find the second or third or .... non-blank cell in the column.

Thanks

 

[Carl Witthoft]

I want to use it in a formula. So I have a column which is mostly blank
cells, and I want to set another cell to the value of the first
non-blank one.

That's my requirement atm, but I wondered whether it was possible to
find the second or third or .... non-blank cell in the column.

Thanks

see MATCH(!ISBLANK..... and functions of that ilk.