zeroes

[larry]

I am during an comparisons on 30 different companines on
several products, what I need is the lowest prices
without the zeroes or blanks being shown before or after
the sort. please help

 

[Myrna Larson]

You can try this array formula (enter with CTRL+SHIFT+ENTER)

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

MIN will already ignore blank cells. The array formula converts the 0 values
to FALSE, which MIN will also ignore.

 

[Chris Mitchell]

Tools/Options/View uncheck Zero values. This will prevent 0s being
displayed.

 

[Myrna Larson]

Probably. Try it and find out.

The "D" functions have the added aggravation of requiring a Criteria Range.