Most valuable professional
  • Hot Topics

Excel Finding latest value in multiple columns that meets criteria and is bigger than 0

Trying to figure this one out, but haven't succeeded yet. I want to find the latest value in two columns (B and F) with some columns in between that match a criteria and the value must be bigger than 0. Below, the criteria is B15 and the result should be 170 in cell D15. Hope someone can help me with this, because the columns in between and the empty row are killing me. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

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

This thread is current as of July 1, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel