Hey all,
I am looking for some help creating a formula to analyze some health data that I am looking at. I have a range of testing dates for a preventative screening and I am looking to calculate the average of the 2 highest values separated by 21 days. I will attach a sample spreadsheet of an example of what it looks like, but I want to be able to replicate this over multiple samples (around 200 or so different groupings of testings). I have played around using a few different functions, but have failed to put it all together. I appreciate help in any way possible. Thank you!
I am looking for some help creating a formula to analyze some health data that I am looking at. I have a range of testing dates for a preventative screening and I am looking to calculate the average of the 2 highest values separated by 21 days. I will attach a sample spreadsheet of an example of what it looks like, but I want to be able to replicate this over multiple samples (around 200 or so different groupings of testings). I have played around using a few different functions, but have failed to put it all together. I appreciate help in any way possible. Thank you!
Days Post | Test score | ||
pt1 | 2 | 1.5 | |
pt1 | 21 | 2 | |
pt1 | 34 | 3 | |
pt1 | 35 | 2 | |
pt1 | 61 | 5 | |
pt1 | 100 | 6 | |
pt1 | 121 | 2 | |
pt1 | 122 | 7 | |
pt1 | 134 | 8 | |
pt1 | 156 | 1.4 | |
pt1 | 200 | 5.3 | |
pt1 | 455 | 3.4 | |
pt1 | 1133 | 2 | |