Hi there.
I have 3 columns called Date_Assess, First_Last, and SDQ_Total that represent the date of the assessment, the first and last name combined, and the total score on the SDQ scale. These are filled in manually.
I have created 3 more columns called Last_SDQ, SDQ_Difference, and SDQ_Improval. What I'm aiming for is to create a formula in the Last_SDQ column that will use the Date_Assess and First_Last variables to find the previous year's SDQ_Total value in each row. Then it would be easy to make a formula in the SDQ_Difference column that subtracts the current value from the previous value, and understand whether the child has improved in the SDQ_Improval column from last year's measurement.
Any ideas on the formula I described for Last_SDQ?? I've been around and around and I feel like I'm on the verge but just can't get it right. I've attached a picture of the spreadsheet. I would appreciate your insight!!
Thank you,
Alison
Bookmarks