pick lowest value from a set of cells

[jdmillerinc1]

I'm trying to set up a spread sheet that can take pricing from mutiple vendors for several different materials and chose the best price

I have all the materials in a single column, and columns for the price of each vendor, and a column for the best price using the min function.

Problem is not all vendors price each and every item. I want the best price column to ignore any "0" values, but the MIN function will always return the 0

 

[Joe4]

See: Excel Ignore cell with 0 in Min formula

 

[Jonmo1]

Welcome to the board.

Try

=SMALL(A1:A10,1+COUNTIF(A1:A10,0))

 

[jdmillerinc1]

This almost works. Problem is Each Vendor has two columns one for unit price and one for total price (unit price times quantity). and I do want to keep that so I can compare price savings by buying each item for the lowest vendor or all from one.

How can I adapt your formula to look at every other cell in the row?