+ Reply to Thread
Results 1 to 4 of 4

Weight Loss Tracker (Work out total weight loss from weekly data) Show results in league t

  1. #1
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    480

    Weight Loss Tracker (Work out total weight loss from weekly data) Show results in league t

    Hello
    Column B – Is a Starting weight, Weekly weigh is from C-N - in O I want to work out the total weights loss…


    Please see attached - To help with explanation

    Cheers
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Weight Loss Tracker (Work out total weight loss from weekly data) Show results in leag

    In O2 copied down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    The INDEX/MATCH finds the last recorded weight in that row. It is set up such that weight loss is positive and weight gain is negative
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Weight Loss Tracker (Work out total weight loss from weekly data) Show results in leag

    Also, if you want to create that separate table in row 15,
    I created a unique ranking in Q2 copied down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In B15 copied down (similar formula in C15)
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Questions or issues?
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    480

    Re: Weight Loss Tracker (Work out total weight loss from weekly data) Show results in leag

    Fantastic Chemist, thank you very much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Running Formula for Total Weight Loss Percentage
    By ExcelDummy77 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-06-2016, 10:58 AM
  2. [SOLVED] Total Weight loss formula?
    By Man-Dingo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-28-2015, 05:30 AM
  3. Weight loss tracker
    By missthomas in forum Excel General
    Replies: 2
    Last Post: 08-12-2014, 08:21 PM
  4. creating a time off tracker for work and I am at a total loss.
    By evolution4652 in forum Excel General
    Replies: 2
    Last Post: 02-06-2014, 02:50 PM
  5. Autofill:create a graph to show my daily weight loss
    By WRubin in forum Excel General
    Replies: 2
    Last Post: 03-29-2010, 07:01 PM
  6. tracking weight loss
    By poohbear802 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-12-2008, 01:08 PM
  7. Weight loss line chart to monitor weight loss progress
    By S Fox in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-08-2005, 01:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1