Forum Discussion

Copper Contributor

Feb 08, 2022

Calculating a difference for lab results for only those with more than one result

Hello, Is there a way to calculate the difference in values for an individual only if there is more than one value for a particular referred value? For example I have the test results for over 1000...

Formulas and Functions

tana96799

Copper Contributor

Feb 08, 2022

cklingel

fyi im using xl v.2013. here's what the data and the rpt looks like. you'll have to do minor calc on the side but it's really easy...not sure if you wanted to subtract the 1st lab test from the last or vice versa, in my rpt your subtracting the 1st lab result from the latest