Reporting latest value in a column

[Merlin Archer]

Good morning, Hive mind!

I'm trying to lose weight, and at my age its not easy. To keep tabs on my progress I have set up a chart showing my weekly weight throughout the year. The chart is fed from a data entry sheet in which I record my weekly weight in a column; IF functions in other columns then derive my total weight loss so far, my average weight loss per week and the weekly loss required to meet my target of 99kgs by thr end of the year. (Yes I know its sad, but what can I tell you? - I'm bored to death in retirement and like to keep what basic skills I have alive...)

I'd like to add a summary box beneath the chart showing the latest results from each of these columns. Could some kind person tell me how I get cells in that box to report the latest data in a column on the data entry sheet? I'm sure there's a simple answer - but its only simple once you know...

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

See if this would help.

23 07 17.xlsm
	A	B
1	Date	Weight
2	12-Jul-23	106.2
3	13-Jul-23	106.0
4	14-Jul-23	106.1
5	15-Jul-23	106.1
6	16-Jul-23	105.9
7	17-Jul-23	105.8
8
Data Entry

23 07 17.xlsm
	A	B	C
1		Date	Weight
2	Last Values	17-Jul-23	105.8
Last Values

Cell Formulas
Range	Formula
B2:C2	B2	=LOOKUP(9^9,'Data Entry'!A:A)