zeroes

  • Thread starter Thread starter larry
  • Start date Start date
L

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
 
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.
 
This is only for clarification of the cobweb in my mind. . What he wants the
lowest price without taking into consideration 0s and blanks. can we not
use
DMIN function with criteria >0. will this give an error
 
Probably. Try it and find out.

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