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
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
In O2 copied down
Formula:
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
Also, if you want to create that separate table in row 15,
I created a unique ranking in Q2 copied down
Formula:
Please Login or Register to view this content.
In B15 copied down (similar formula in C15)
Questions or issues?Formula:
Please Login or Register to view this content.
Fantastic Chemist, thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks