Calculating the difference between the value in a cell, and the latest entered result in the row

[tomo1985]

Hi All,

I am trying to calculate the amount of weight loss/gain, from the first measure, to the most recent.

The range of cells i am using are from B3-M3, with the difference to be shown in N3.

In cell B3 i have the initial weight, then the weights will be updated once a month, along the row.

Can anyone please help me to automatically calculate the difference from the first entry (B3) to the most recent entered.

I have tried to attach a photo but it says the file is too large.

Any help will be much appreciated.

Cheers

 

[jtakw]

Hi,

Something like this?

Book3.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Initial LB												Gain/Loss +/-
2
3	100	105	110	103	99	101	95	103					3
Sheet889

Cell Formulas
Range	Formula
N3	N3	=-(B3-LOOKUP(9^9,B3:M3))

 

[Peter_SSs]

Welcome to the MrExcel board!

.. or you could eliminate one negation.

21 04 02.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Initial LB												Gain/Loss +/-
2
3	100	105	110	103	99	101	95	103					3
Loss

Cell Formulas
Range	Formula
N3	N3	=LOOKUP(999,B3:M3)-B3

I have tried to attach a photo but it says the file is too large.

Photos are not much good anyway as we cannot copy from them to test with. Much better to use XL2BB for providing small sets of sample data.

 

[tomo1985]

Y

Hi,

Something like this?

Book3.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Initial LB												Gain/Loss +/-
2
3	100	105	110	103	99	101	95	103					3
Sheet889

Cell Formulas
Range	Formula
N3	N3	=-(B3-LOOKUP(9^9,B3:M3))

Yep, exactly how i want it. Thankyou so much

 

[jtakw]

You're welcome, thanks for the feedback.

This note just for fun: @Peter_SSs , just trivial, according to Guinness, the heaviest person recorded (so far) is 1400 lbs, so you might want to up your 999

History of heaviest humans as world's biggest man loses half his body weight

The world's most obese man has slimmed down by half his body weight. Juan Pedro Franco Salas made headlines in November 2016 when he weighed 594.8 kg (1,311 lb 4.9 oz; 93 st 9 lb), but now he's lost 45 st. How does his weight loss compare with previous holders of the heaviest man record?

www.guinnessworldrecords.com

PS: my 9^9 is a overkill...

 

[Peter_SSs]

according to Guinness, the heaviest person recorded (so far) is 1400 lbs, so you might want to up your 999

?