Minimum (Non-Zero) Value in a column

[Ian James]

I have a worksheet that has a number of rows for data entry, currently
the end column is 0 by default until details are entered into the row.

I want to have a value similar to a total at the bottom of the column,
but that actually displays the minimum value in the totals but I
cannot stop it showing 0 as the minimum number.

I thought that DMin would do what I ask, but I cannot get to grips
with the syntax.

So for example if I have an end total column of

Units Per Year
351,000
125,000
102,000
194,000
225,000
0 } Available for
0 } other data
0 } to be
0 } entered
-------
102,000 < This should be the limiting factor for the year being the
minimum non zero figure in the total column.

Can anybody help or suggest a better way to do this

Thanks in advance


Ian James

 

[Frank Kabel]

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=MIN(IF(A1:A100>0,A1:A100))

 

[DNF Karran]

Could you not change the 0 to "" as default then the MIN() functio
would be fine?

Dunca

 

[DNF Karran]

Otherwise:

=MIN(IF(A1:A10<>0,A1:A10))

and array enter (ctrl+shift+enter)

Dunca