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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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
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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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.