Smallest value in an Excel range - ignoring blank, text or error cells
This presentation will provide you two approaches to find the smallest value across blank, text or error cells in a financial model.
The standard MIN function in Excel will be unable to cope with a range, which has non-numerical cell values such as errors, blanks or text.
We require an alternative function and formula, which will derive the smallest value of 9,080.
Feel free to also check out the earlier videos, "Sum an Excel range - ignoring blank, text or error cells" ( • Sum an Excel range - ignoring blank, text ... ), "Average an Excel range - ignoring blank, text or error cells" ( • Average an Excel range - ignoring blank, t... ) and "Largest value in an Excel range - ignoring blank, text or error cells" ( • Largest value in an Excel range - ignoring... )