Most valuable professional
  • Hot Topics

Excel Formula to find last non blank cell value in a range

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!

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of August 6, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel