Forum Discussion
Weight loss in lbs. and body fat %
serene06 In the attached I expanded the file/table to include ID and week and formatted as a table to use structured references. The formulas find the value for the row with the same ID AND says "start" under the Week and subtract from there. I do this all under 1 table as it does make a number of things easier (i.e. any kind of group metrics like my clients lost a total of or average of ...).
i also added another tab to help you pull ONLY a single person's info. I used a pivot table but you could also use the FILTER() functions.
Thanks for your response. This was helpful.
Thus, I am tracking several individual weights and body fat %s. What is the best way to capture this in Excel. In addition, how do I copy the formula for each individual?
serene06 In the attached I expanded the file/table to include ID and week and formatted as a table to use structured references. The formulas find the value for the row with the same ID AND says "start" under the Week and subtract from there. I do this all under 1 table as it does make a number of things easier (i.e. any kind of group metrics like my clients lost a total of or average of ...).
i also added another tab to help you pull ONLY a single person's info. I used a pivot table but you could also use the FILTER() functions.
- Thanks for your help!