Create a Weight Tracking Worksheet in Excel with the OFFSET Function

I use this method in my Google Sheet fitness tracker, but of course, we can do the same thing in Excel. Use the OFFSET function to calculate a median of the current weight and the six prior weight entries. A little bit of IF function is used too so that we can only display the median on Saturdays that are past or present, not in the future.

[MikeMarq]

Where is the chart? You said see you in a bit lol, I like your video and how you tap the keys 😊

[KingIsComing]

Did you record the follow up video? I’m having trouble locating it for the graphing. Thanks for this tutorial as it was very helpful