This works a treat. Many thanks.
--
kinsey


"JLatham" wrote:

=SMALL(A1:A100,COUNTIF($A$1:$A$100,0)+1)
Assumes your values are in column A between rows 1 and 100, adjust according
to your sheet setup.

This came from:
http://www.ozgrid.com/Excel/minimum-without-zero.htm

Enjoy!

"kinsey" wrote:

I have a quotation form I use which has several supplier values in a column.
I want to calculate the minimum value but because every supplier does not
always
give a quote their value will show zero. In short I want the minimum in the
column
but excluding zero. How do I express this?


--
kinsey