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, ... ), "Average an Excel range - ignoring blank, text or error cells" ( • Average an Excel range - ignoring bla... ) and "Largest value in an Excel range - ignoring blank, text or error cells" ( • Largest value in an Excel range - ign... )
Watch video Smallest value in an Excel range - ignoring blank, text or error cells online without registration, duration hours minute second in high quality. This video was added by user Strategize Financial Modelling 26 February 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,364 once and liked it 10 people.