Conditional FormulaI am trying to add a column formula that is conditional to other columns. I have data where “Results” Column is stacked by “Subject” and “Product” with multiple values over “Time”. I’m trying to calculate the baseline for each value in “Results” so that:
New Column = "Results" – ["Results" value where Time=(1) for that particular Subject/Product combination]
Thank you
Automation and Scripting