Forum Discussion
StDev of values in column X for all rows with identical values in column Y
KadieB Your indicated you have Excel365 so you have FILTER and UNIQUE functions. in the Attached I created a small table based on using those functions. In Columns F&G are using regular references which means you need to adjust the range based on the amount of data. In columns I&J I use TABLE references so as you have more or less data in the table (I defined the data to be a table) the formulas will automatically scale. That said, the formula for std dev in both cases needs to be pulled down to include all the unique values found in the previous column.
KadieB Your indicated you have Excel365 so you have FILTER and UNIQUE functions. in the Attached I created a small table based on using those functions. In Columns F&G are using regular references which means you need to adjust the range based on the amount of data. In columns I&J I use TABLE references so as you have more or less data in the table (I defined the data to be a table) the formulas will automatically scale. That said, the formula for std dev in both cases needs to be pulled down to include all the unique values found in the previous column.
You could also use a pivot table.
A in rows area.
B in values area. Change the calculation to StDev.
