Quote Originally Posted by Coaster View Post
is this what you wanted?

this file may need revising, especially because the formula is almost undecipherable but let us know if i'm on the right track
Thanks for working on this! Your spreadsheet looks like it gives me the information I need, but I have no idea how to translate that to my own spreadsheet! I also need to take the data one step further...you gave me the average weekly weight for each patient...from there I need to calculate the change in average weekly weight from week to week (i.e. 2 lbs gained).

I uploaded a sample spreadsheet in reply to DonkeyOte's post above...perhaps that will help make my situation more clear?

Please let me know if you require further explanation! Thanks again, I really appreciate your help!