How to find the minimum value in a range while ignoring the 0 value



In this example we cannot use the function Min (Minimum), because it will only find the smallest value in a range of cells. However the Small Function allows you to choose the Smallest and also the second smallest, third smallest and so on. READ MORE