Lowest number excluding zero

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

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top