How can I use min function with ignore zeros

**migdad** · 10-20-2013, 03:45 AM

Gentlemen,
I would like to now the minimum number greater than zero.

Example numbers
7
3
0
9
5
7
4
3

The result should be 3

Regards

**SDCh** · 10-20-2013, 03:50 AM

use this (array formula, use Ctrl+Shift+Enter):

Please Login or Register  to view this content.

**XOR LX** · 10-20-2013, 04:06 AM

Alternative, non-array solution (courtesy of daddylonglegs):

=SMALL(A2:A9,COUNTIF(A2:A9,0)+1)

Regards

**migdad** · 10-20-2013, 04:32 AM

Dear SDCH,
Thanks for try to help, but your formula not work

XOR LX,
Thanks for help, It is working.

Regards

**SDCh** · 10-20-2013, 06:17 AM

not work?
You may be not do what I said : use "Ctrl+Shift+Enter", because it an array formula if you just press Enter it will not work.

Re: How can I use min function with ignore zeros