Results 1 to 2 of 2

Thread: Range of data difference compared to 1 cell - output in another cell PLEASE HELP

  1. #1

    Range of data difference compared to 1 cell - output in another cell PLEASE HELP



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I want to keep some running data measurements across several columns. I then want to take this data (most recent most important) and find the difference (whether + or -) and have that result to show up in another cell. (i would post a screenshot, but newbies can't do that )

    example:

    starting weight in C6

    weight measurements in cells B23:B30....

    I want to compare the data B23:B30 to my starting weight in C6 and have this calculated in cell B18

    When I put in another measurement in B31..., I then want cell B18 updated with the new measurement

    I want my measurements to reflect (-) if I have lost weight or (+) if I have gained.

    Can someone please help me with this. I am not very fluent with Excel and really looking for a spreadsheet to help me with my weight loss. thanks so much!!
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	excel help.jpg 
Views:	21 
Size:	92.1 KB 
ID:	3406  

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    plz see the file. is this help ?
    Attached Files Attached Files

Posting Permissions

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