Well complex is a relative term but the way I receive data is in a bundle that has multiple analytes and multiple IDs. We always have per Analyte and Patient ID a singular baseline Timepoint ("C1D1 0"). I can do it like excel but honestly a much more elegant way of doing is to make a formula for when I receive another batch of data of longitudinal data I can just add that and it will be transformed. Also, having such formulas would help for another analysis that will also be delivered in the same fashion.
So, basically I want to create a formula that matches (or groups?) an Analyte and Patient ID, then finds the Timepoint "C1D1 0" and uses the "Result" cell as baseline and the simplest transformation would be fold change Result X/Result Baseline. All other transformations would be derivatives, %change from baseline and log2 change from baseline.
Please let me know if I have explained this properly but in essence I would like a formula to do the heavy lifting without the need for too much data manipulation.
Many thanks for your help.