Conditional formula
In the following table, I would like to create a column in which each "Sample" value is divided by the average of "Control" grouped by X.For examples, each "Sample" in "X1" will be divided by average of "Control" from "X1", each "Sample" in "X2" will be divided by average of "Control" from "X2".I can get the mean of "Control" by creating a formula that calculates Col Mean grouped by "X" and "Type"...