Lowest number excluding zero

[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.

 

[Bernard Liengme]

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

 

[FrankWood]

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