Calculate standard deviation based on conditions.

Hi Experts,

I have a requirement to validate the values (cost & prices) in the product list based on following conditions and then calculate the deviation in the cost & price of material.

1. Material #
2. Vendor ID & name
3. Currency

Ideally the product list should have same cost and prices for the materials with same currency and vendor irrespective of the country.

Hi,

From what I can see the topic does not correspond with the desired result. Standard deviation is a measure that quantifies the amount of variation and applies on a set of values of the same matter. In your sample you calculate the difference between two values in %. Unless it is clear exactly what you need I do not see how to help.

Hi,

I want to know if a part (with same vendor and currency) has different cost or price in the data.

E.g in sample data:
1. Part # OFF-AR-10002833 has different price in Canada region but the cost is same for both US and Canada.
2. Similarly part # OFF-BI-10003910 has different cost in Canada but same price for US and Canada.
3. Part # FUR-BO-10001798 has same cost and price for both US and Canada.

Hope this helps.

JeteMc,

Thanks, your solution eases my work a bit with the formula. I am using two pivot tables, each for cost & price. Just wondering if there's any way out without the pivot table as I have a huge list to work with.

Thanks for the help! This is very helpful.