Hello,
I need to subtract baseline score from the most recent score for a specific id. I was filtering and subtracting for each case number but there are too many entries and some have multiple dates. Please help! What is the most efficient way to do this? Formulas? I need it in the D) Results column. (I have beginner skills :/) (Using 2010 Excel on windows.)
Please see below:
A B C D
[TABLE="width: 389"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]CASE_NUM[/TD]
[TD] Date [/TD]
[TD] Average Functioning Score[/TD]
[TD] RESULT[/TD]
[/TR]
[TR]
[TD="align: right"]418557[/TD]
[TD="align: right"]5/10/2018[/TD]
[TD="align: right"]1.27[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]418557[/TD]
[TD="align: right"] 11/16/2018[/TD]
[TD="align: right"]1.27[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417870[/TD]
[TD="align: right"]5/9/2018[/TD]
[TD="align: right"]1.47[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417870[/TD]
[TD="align: right"]11/15/2018[/TD]
[TD="align: right"]1.47[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417841[/TD]
[TD="align: right"]5/4/2018[/TD]
[TD="align: right"]1.40[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417841[/TD]
[TD="align: right"]11/8/2018[/TD]
[TD="align: right"]1.40[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417131[/TD]
[TD="align: right"]4/20/2018[/TD]
[TD="align: right"]1.20[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417131[/TD]
[TD="align: right"]10/23/2018[/TD]
[TD="align: right"]1.20[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417026[/TD]
[TD="align: right"]4/26/2018[/TD]
[TD="align: right"]1.33[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417026[/TD]
[TD="align: right"]10/30/2018[/TD]
[TD="align: right"]1.33[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]416700[/TD]
[TD="align: right"]4/18/2018[/TD]
[TD="align: right"]0.87[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]416700[/TD]
[TD="align: right"]10/18/2018[/TD]
[TD="align: right"]0.87[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]416692[/TD]
[TD="align: right"]4/9/2018[/TD]
[TD="align: right"]1.13[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]416692[/TD]
[TD="align: right"]10/8/2018[/TD]
[TD="align: right"]1.13[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
Thank you
I need to subtract baseline score from the most recent score for a specific id. I was filtering and subtracting for each case number but there are too many entries and some have multiple dates. Please help! What is the most efficient way to do this? Formulas? I need it in the D) Results column. (I have beginner skills :/) (Using 2010 Excel on windows.)
Please see below:
A B C D
[TABLE="width: 389"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]CASE_NUM[/TD]
[TD] Date [/TD]
[TD] Average Functioning Score[/TD]
[TD] RESULT[/TD]
[/TR]
[TR]
[TD="align: right"]418557[/TD]
[TD="align: right"]5/10/2018[/TD]
[TD="align: right"]1.27[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]418557[/TD]
[TD="align: right"] 11/16/2018[/TD]
[TD="align: right"]1.27[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417870[/TD]
[TD="align: right"]5/9/2018[/TD]
[TD="align: right"]1.47[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417870[/TD]
[TD="align: right"]11/15/2018[/TD]
[TD="align: right"]1.47[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417841[/TD]
[TD="align: right"]5/4/2018[/TD]
[TD="align: right"]1.40[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417841[/TD]
[TD="align: right"]11/8/2018[/TD]
[TD="align: right"]1.40[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417131[/TD]
[TD="align: right"]4/20/2018[/TD]
[TD="align: right"]1.20[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417131[/TD]
[TD="align: right"]10/23/2018[/TD]
[TD="align: right"]1.20[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417026[/TD]
[TD="align: right"]4/26/2018[/TD]
[TD="align: right"]1.33[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]417026[/TD]
[TD="align: right"]10/30/2018[/TD]
[TD="align: right"]1.33[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]416700[/TD]
[TD="align: right"]4/18/2018[/TD]
[TD="align: right"]0.87[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]416700[/TD]
[TD="align: right"]10/18/2018[/TD]
[TD="align: right"]0.87[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]416692[/TD]
[TD="align: right"]4/9/2018[/TD]
[TD="align: right"]1.13[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]416692[/TD]
[TD="align: right"]10/8/2018[/TD]
[TD="align: right"]1.13[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
Thank you