|  

» 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


Rate This Tip
12 34 5
Rating: 3.18     Views: 41770
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments