MIN Value ignore "0"

[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

Each row is a different material
Column for material by name and one fore unit price
column for Best price using the formula below
Two columns for each vendor, one showing the unit price and one showing total price (unit price times quantity)

Problem is that I have two columns for each vendor in the rows. I need the formula to check only the columns with unit pricing, and to skip the total price.

Also since not all vendors price each and every item. I want the best price column to ignore any "0" values.

=SMALL(D12:R12,1+COUNTIF(D12:R12,0))

 

[jtakw]

Asked here: http://www.mrexcel.com/forum/excel-questions/940438-pick-lowest-value-set-cells.html

 

[Macropod]

jdmillerinc1: Please read our policy against Duplicate Posting in rule #12: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

Thread closed.