I need help finding the value of the last non blank cell in the range (CO40:DB40). These cells do have formulas in them. Some cells may have zero (0) values. If cells (CO40:DB40) are all blank, than I'd like the answer to be zero (0). Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formula to find last non blank cell value in a range
- Thread starter G00DNESS
- Start date
Caribeiro77
Well-known Member
- Joined
- Sep 24, 2010
- Messages
- 1,261
Maybe:
=IF(COUNTA(CO40:DB40)=0,0,INDEX(CO40:DB40,MAX(IF(CO40:DB40<>"",ROW(CO40:DB40)))))
End with:
CTRL+SHIFT+ENTER
=IF(COUNTA(CO40:DB40)=0,0,INDEX(CO40:DB40,MAX(IF(CO40:DB40<>"",ROW(CO40:DB40)))))
End with:
CTRL+SHIFT+ENTER
Upvote
0
It returns #Name?
Upvote
0
Caribeiro77
Well-known Member
- Joined
- Sep 24, 2010
- Messages
- 1,261
Did you press CTRL+SHIFT+ENTER to confirm?
I checked again and worked just fine in my data!!
I checked again and worked just fine in my data!!
Upvote
0
Weazel
Well-known Member
- Joined
- Dec 24, 2011
- Messages
- 3,155
yeah, you're gonna have to do a little better than that as far as explaining things.
what version of excel?
Are you returning a number or text?
the lookup works on both so I'm not sure why your getting a #value error especially since the iferror would trap it and return 0
did you type out the formulas or copy and paste them?
what version of excel?
Are you returning a number or text?
the lookup works on both so I'm not sure why your getting a #value error especially since the iferror would trap it and return 0
did you type out the formulas or copy and paste them?
Upvote
0
Are all of the cells formula-driven, or just some? Do the formulas return blanks ("") or 0s?
A small example would help us to understand what we're dealing with.
Matty
Upvote
0
