MIN Value ignore "0"

Status
Not open for further replies.

jdmillerinc1

New Member
Joined
Dec 15, 2015
Messages
5
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))
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Status
Not open for further replies.

Forum statistics

Threads
1,226,730
Messages
6,192,705
Members
453,748
Latest member
akhtarf3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top