Lowest number excluding zero

  • Thread starter Thread starter djbeaver
  • Start date Start date
D

djbeaver

I have five columns for each vendor and I am trying to determine who has the
lowest price out of the seven vendors. The data is not in an array. The
critical data would be in i.e. cells: T20, Z20, AF20, AL20, AQ20 and AV20. I
want to calculate the lowest price excluding zero out of those cells.
 
I experimented by putting numbers into B4, C5, D6 and E7
I used Insert | Name | Define (in XL 2003) to define MYDATA to refer to
=Sheet1!$B$4,Sheet1!$C$5,Sheet1!$D$6,Sheet1!$E$7
In XL 2007 use Formulas | Define names | Define Name

Then In a cell I typed =MIN(mydata) and it returned the lowest value from
the four cells.
You can readily adapt this to your case
best wishes
 
If you want to simply find the lowest value in the cells you indicated you
could just try:

=MIN(T20,Z20,AF20,AL20,AQ20,AV20)

Does that hel?

Cheers,

Frank
 
Back
Top