Forum Discussion
Find lowest price along with that vendor's name
Hello, On one tab, "BOM BRKDN", I have a materials list with several unique part numbers. On a second tab, "PRICING", is a list of all vendor quotes for all part numbers. I have a "Best Pri...
Corey,
replace your data in sheet "BOM BRKDN" with a pivot table based on sheet "PRICING".
"part number" and "vendor" in row area and "price" in values area. Change the aggregation to "Min".
Corey,
replace your data in sheet "BOM BRKDN" with a pivot table based on sheet "PRICING".
"part number" and "vendor" in row area and "price" in values area. Change the aggregation to "Min".
Thank you Detlef!
This will get me where I need to be.
