Hello, I'm still figuring out how to ask this question, so apologies if it has been asked elsewhere. Links appreciated.
I am trying to highlighted the product priority for an end customer, and compare it to the product priority for the supplier. I want to take this further by calculating which Supplier supplies the specific end customer more often to choose which supplier to give priority for that product, with a conditional formula to look at the next supplier if that product is not supplied by that supplier.
In the attached example sheet, I have two end customers: Papa Johns and Dominos; three suppliers: Supplier A, B and C; four products: Tomatoes, Cheese, Dough, and Green Peppers; and a priority scale of 1 (lowest) to 5 (highest)
Papa Johns prioritizes tomatoes at 5, Cheese at 4, Dough at 2, and Green Peppers at 3. Supplier A handles 48.1% of the resupply shipments into the store.
Dominos prioritizes tomatoes at 4, Cheese at 4, Dough at 5, and Green Peppers at 1. Supplier B handles 42.0% of the resupply shipments into the store.
Supplier C is the only supplier to provide Dough.
Problem: How do I use a formula to find the Max in the Range F3:H3, then return the corresponding Row 2 value? I believe I can handle the rest from there, but will appreciate any help offered on the rest of the problem.
Bookmarks