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!
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)
What are the formulas in those cells?
Matty
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!