# Min > 0

#### Samkillian

##### New Member
Is there a way to use the Min function to look at a range with zero's included, but ignore them. I'm trying to create a sheet where i am figuring out a price, but i need to compare it and have it no less then the min of our top selling products. Unfortunately, our top products don't sell in all markets and zero's are possible. Thx

### Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

#### jeffreybrown

##### Well-known Member
Sam,

See if this works for you. Enter the formula with Ctrl+Shift+Enter. If done correctly you will get the {} brackets.

Excel Workbook
L
91
102
113
124
135
146
157
160
17
181
Sheet7

#### barry houdini

##### MrExcel MVP
You can use an array formula like this

=MIN(IF(A1:A100>0,A1:A100))

confirmed with CTRL+SHIFT+ENTER

...or non-array

=SMALL(A1:A100,COUNTIF(A1:A100,0)+1)

#### Samkillian

##### New Member
Awesome, worked great. Thanks.

Replies
1
Views
141
Replies
3
Views
325
Replies
4
Views
675
Replies
1
Views
357
Replies
5
Views
236

1,190,883
Messages
5,983,387
Members
439,841
Latest member
goodwillhunting

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back