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
The cells are not formula driven. I realize now that I made an error in my orig post. Correction: I enter number amounts in them (i.e. 3,000.00) as needed, and there are no formulas in them.
Upvote
0
Excel Facts
VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Will the range only ever contain numbers? Or could letters (text) be in there, too?
Upvote
0
Only numbers w/ the decimal
Upvote
0
It works like a charm Matty.
Thank you ever so much! One more question please Matty. When I later go to use this spreadsheet on my other laptop w/ MS Excel 2013, I know it will convert from xls to xlsx. When that happens, will there be an issue with this formula?
Upvote
0
It works like a charm Matty.
No problem.
The formula should work on all Excel versions.
Matty
Upvote
0
No problem.
The formula should work on all Excel versions.
Matty
One more question please Matty...is there any way to alter the formula so that the cell value returned is blank instead of showing zeroes?
Upvote
0
Upvote
0
I did that before I asked. Still returned 0.00
Upvote
0
Upvote
0
