Formula to find last non blank cell value in a range

[G00DNESS]

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!

 

[G00DNESS]

Works OK for me. Are you sure the cells are all empty?

Matty

It works in the range given above. I tried to use the same formula in a different range--formula driven (all cells having formulas in them), and it shows zeroes. I used: =IF(COUNT(CO49:DA49),LOOKUP(9.99999999999999E+307,CO49:DA49),0)

 

[Matty]

It works in the range given above. I tried to use the same formula in a different range--formula driven (all cells having formulas in them), and it shows zeroes. I used: =IF(COUNT(CO49:DA49),LOOKUP(9.99999999999999E+307,CO49:DA49),0)

What are the formulas in those cells?

Matty

 

[G00DNESS]

What are the formulas in those cells?

Matty

I was able to figure it out Matty. Thanks for all of your help!

 

[Aladin Akyurek]

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!

You actually want the last numeric value of CO:DB40, right. If so:

=LOOKUP(9.99999999999999E+307,CO:DB40)

If you want the last non-zero numeric value:

=LOOKUP(9.99999999999999E+307,1/CO:DB40,CO:DB40)