Feb 3, 2014
question 1 : In the below sheet, is there a way to use the condition highlighting the quantity for each item which has the lowest (prices/pcs) value?
View 1 Replies
for example : comparing the ITEM 1 -> $8/10 , $6/8, $9/20, $11/20
and highlight the 8pcs for item 1, indicates item 1, seller bill has the best offer.
Question 2 : Since I will have at least 50 items, is there a way to just copy the formula and apple to each row ?
question 3 : I would also like to apply a formula that can calculate the price and quantity of each item. for example : on the I column, for Item 1, i would love to order 3 orders, since bill has the best offer, so I will have 24pcs on column I3. And i would love to apply such formula to each item for each row.
Question 4 : For the cell J3, I would like to know if bill has the best offer for the item 1, order 3 orders, the price for item 1 will be $18. And I would like to apply such formula to each row for each item.
I do not want to create another column for each seller: such as ($/pcs) to find out the best offer, since i will have at least 35suppliers , and try to make the sheet look as nest as possible.