Find the last blank cell

Closed
vutanhuynh
Posts
2
Registration date
Wednesday June 22, 2016
Status
Member
Last seen
June 22, 2016
- Jun 22, 2016 at 02:44 PM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Jun 23, 2016 at 09:47 AM
Hello,
I am looking for a formula/method of finding a last blank cell in a column
example
column A
1
2
3
4
blank cell
1
2
3






blank cell
1
2
thanks

3 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Jun 22, 2016 at 06:30 PM
vutanhuynh, Good evening.

Suppose your data is at A1:A10

B1 -->
="A" & SUMPRODUCT(MAX((A1:A10="")*(ROW(A1:A10))))

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
vutanhuynh
Posts
2
Registration date
Wednesday June 22, 2016
Status
Member
Last seen
June 22, 2016

Jun 22, 2016 at 10:15 PM
Hi Mazzaropi,
thanks for quick respond, I sorry that given you incomplete info. please review below what I try to get is in column C
thanks

A B C
1
2
3
4
1
1
2 2
3
1
2
3
4
5
6
7
1
2 2
1
1
2 2
3
0
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Jun 23, 2016 at 09:47 AM
vutanhuynh, Good evening.

At your first message you asked for:
"I am looking for a formula/method of finding a last blank cell in a column"
I gave you one formula that does what you want.

NOW, at your last post I can't understand your necessity.

Please, explain with details what you want.
It's easier to help you.
0