Help Weight Loss

[agoodson56]

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> I am trying to build a weight loss tracker that runs left to right in a row.

In a row I am entering my weight each Monday for 14 weeks.

At the end of the row I want to total what my weight loss is or what my new weight is.

 

[Airfix9]

To show latest entry:

=INDEX(A1:AZ1,MATCH(9.99999999999999E+307,A1:AZ1))

To show total loss:

=A1-INDEX(A1:AZ1,MATCH(9.99999999999999E+307,A1:AZ1))

 

[T. Valko]

I am trying to build a weight loss tracker that runs left to right in a row.

In a row I am entering my weight each Monday for 14 weeks.

At the end of the row I want to total what my weight loss is or what my new weight is.

It's not real clear what you want to do.

It would seem to me that what you might want is to find the difference of the initial (very first) weight entry from the most recent weight entry.

Like:

150
147
145
148
144

So, it woud be 150 minus 144 = 6

Is that what you had in mind?

 

[agoodson56]

It does not seem to work

I am using row 4 cells 4F - 4AF.

Cell F4 is my starting weight

 

[T. Valko]

It does not seem to work

I am using row 4 cells 4F - 4AF.

Cell F4 is my starting weight

Try it like this...

=F4-LOOKUP(1000,F4:AF4)

 

[agoodson56]

=F4-LOOKUP(1000,F4:AF4)

I tried this but the cell housing this formula stays that same as cell F4

 

[T. Valko]

=F4-LOOKUP(1000,F4:AF4)

I tried this but the cell housing this formula stays that same as cell F4

Are the cells empty until you enter a weight or do they contain 0s?

 

[agoodson56]

 

[Airfix9]

You need to clear your zeros. All our formulae look for the last value, if it's 0, the difference between the start weight and the end weight is the start weight (270.8 - 0 = 270.8).

Keep future weights blank and the formulae should work.

 

[agoodson56]