Forum Discussion
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...
=XLOOKUP(D2,$A$2:$A$8,$B$2:$B$8,,,-1)-XLOOKUP(D2,$A$2:$A$8,$B$2:$B$8,,,)This formula works as shown in my spreadsheet.
In D2 i entered the formula:
=UNIQUE(A2:A8)
Here's the my data table using your data if that's what you want then let me know i'll send over the formulas