Price comparison

1

The first sheet (Step 1) contains raw input data including purchase prices from different vendors.

2

Customer needed to know difference between average purchase price vs cheapest purchase price per SKU

3

We started off by removing duplicates in PID, Description and Vendor name.

4

Since there are 17 vendors, it`s most convenient to show Vendor prices horizontally. Doing by that, we are able to compare prices per SKU.

5

Using SUMIFS function, we find each SKU prices using PID and Vendor name