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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 23, 2016 at 09:47 AM
Related:
- Find the last blank cell
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Based on the cell values in cells b77 ✓ - Excel Forum
- Excel function question - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Conditional formatting if cell contains text - Excel Forum
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
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
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
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
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
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.
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.
