We're having a weight loss competition at work and I'm trying to set up a
table that will show each persons weight each week, total loss/gain and
percentage of loss. Can anyone help me?

Assuming the weekly weights of a single person are in a column (say in
A2:A10), the formulas:

=A3-A2
=(A3-A2)/A2

will show respectively the net weight change and percent change
(negative values indicate loss. These formulas should be placed in row
3 and can be copied down.

HTH
Kostis Vezerides

Thanks!

"vezerid" wrote:

Assuming the weekly weights of a single person are in a column (say in
A2:A10), the formulas:

=A3-A2
=(A3-A2)/A2

will show respectively the net weight change and percent change
(negative values indicate loss. These formulas should be placed in row
3 and can be copied down.

HTH
Kostis Vezerides

Set up a table like this:
A B C D E X
1 Name Total Percent Start Week 1 Week #

In Cell B2: =D2-OFFSET(D2,0,COUNTA(D2:X2)-1)
In Cell C2: =B2/D2
Copy these formulas down for as many participants as you have.

List out all of your weeks and just enter the official weights each week.
Just make sure that "X" in the formula above is the column letter of your
last week (Figure a year's worth of weeks from the start--you should be good
to go)

Good luck!

"angel5959" wrote:

We're having a weight loss competition at work and I'm trying to set up a
table that will show each persons weight each week, total loss/gain and
percentage of loss. Can anyone help me?

Thanks!

"BekkiM" wrote:

Set up a table like this:
A B C D E X
1 Name Total Percent Start Week 1 Week #

In Cell B2: =D2-OFFSET(D2,0,COUNTA(D2:X2)-1)
In Cell C2: =B2/D2
Copy these formulas down for as many participants as you have.

List out all of your weeks and just enter the official weights each week.
Just make sure that "X" in the formula above is the column letter of your
last week (Figure a year's worth of weeks from the start--you should be good
to go)

Good luck!

"angel5959" wrote:

We're having a weight loss competition at work and I'm trying to set up a
table that will show each persons weight each week, total loss/gain and
percentage of loss. Can anyone help me?