# Non zero minimum value

#### Smit

##### New Member
I have a range of data that I need to find the minimum value for. The problem is I want the minimum value that is not zero. E.g if I have 0,1,2,3 I want it to return 1. I am using the Min function.

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
this question was actually asked in a previous post and answered by Juan Pablo. you want to use an array function. for example if cells A1:A4 house the values 0,1,2,3, you need to enter the following formula:

=MIN(IF(J22:J25,J22:J25))

and instead of pressing enter when completed with the formula, you need to press shift+control+enter, and the cell that contains the formula will return the smallest non-zero number, in this case, 1. after entering your formula, your formula should have '{}' brackets around it

HTH
kevin

CORRECTED:

this question was actually asked in a previous post and answered by Juan Pablo. you want to use an array function. for example if cells A1:A4 house the values 0,1,2,3, you need to enter the following formula:

=MIN(IF(A1:A4,A1:A4))

and instead of pressing enter when completed with the formula, you need to press shift+control+enter, and the cell that contains the formula will return the smallest non-zero number, in this case, 1. after entering your formula, your formula should have '{}' brackets around it

HTH
kevin

I don't hav a clue sorry!

Ha HA Ha

Ha HA hA

Replies
2
Views
90
Replies
6
Views
201
Replies
8
Views
229
Replies
17
Views
271
Replies
9
Views
159

1,203,521
Messages
6,055,890
Members
444,831
Latest member
iceonmn

### 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