smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 162
- Office Version
- 2016
- Platform
- Windows
Hello.
In columns B and C (B2:C600) I have a product list (about 25 different products) and in columns E and F their prices.
When the product is in Column B his price is in Column E (same row) and when the product is in Column C his price is in Column F.
In column H (from cell H2 and downwards) I have list off ALL potential products.
I need a formula to find standard deviation (STDEV) of all prices for each product and put those results in Column I.
example.
<tbody>
</tbody>
cell I2 is STDEV for all apple prices: = stdev(E2,F5,E7,F13)=stdev(12,9,15,13) = 2.5
In columns B and C (B2:C600) I have a product list (about 25 different products) and in columns E and F their prices.
When the product is in Column B his price is in Column E (same row) and when the product is in Column C his price is in Column F.
In column H (from cell H2 and downwards) I have list off ALL potential products.
I need a formula to find standard deviation (STDEV) of all prices for each product and put those results in Column I.
example.
A | B | C | D | E | F | G | H | I | |
1 | Price | Price | Product list | ||||||
2 | apple | sugar | 12 | 10 | apple | 2.5 | |||
3 | orange | milk | 8 | 21 | sugar | ... | |||
4 | flour | cookies | 16 | 3 | orange | ... | |||
5 | cookies | apple | 18 | 9 | milk | ... | |||
6 | cookies | milk | 1 | 22 | flour | ... | |||
7 | apple | orange | 15 | 11 | cookies | ... | |||
8 | sugar | flour | 4 | 9 | |||||
9 | flour | apple | 18 | 13 | |||||
10 | ... | ... | ... | ... |
<tbody>
</tbody>
cell I2 is STDEV for all apple prices: = stdev(E2,F5,E7,F13)=stdev(12,9,15,13) = 2.5