News
Next we need to know which value in column D is the highest or lowest, but only evaluating the values when the corresponding values in column F are TRUE. SEE: 3 ways to suppress zero in Excel ...
Finding the lowest or highest value in an Excel row or column is simple using the MIN() and MAX() functions, respectively. You just drop in the function and specify the range.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback