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.
OliverScheurich I attached a file to better explain what I'm looking for.
I need to calculate standard deviation (or any measure of variability, really) of variable sizes of data in one column. In the attached file, you can see that for every value in column A that is identical, I found the standard deviation of that same range in column B. I am working with thousands of rows of data and 7 or more columns that I want to analyze the variation of, and doing this several times per day, so doing it manually isn't really an option for me.
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.
- Thank you, I think I can make this work!
