Tip Printed from ExcelTip.com
Find the minimum positive value in Microsoft Excel


The following numbers appear in cells A1:A5
A1
-50
A2
-25
A3
25
A4
50
A5
100

Enter the following formula in cell D1: {=MIN(IF((A1:A5>0)*(A1:A5),(A1:A5)))}

The Result = 25

Please note: The formula is an Array Formula, after entering the formula in the cell, press F2 and than press Ctrl+Shift+Enter