Ok - see below.
I have two sets of data recording the weight. One is entered in total lbs
i.e. 120.5 lbs. From this data range, i have created another, showing the
weight in stones and lbs using the fromula you gave me - this is easier for
everyone to understand and track their progress.
From this second data range, I want to pick out the latest weight so that it
can be compared to the starting weight of each member in the group in a
summary part of the spreadsheet. This summary will consist of Column A
(names), Column B (Starting Weight) Column C (Latest Weight) COlumn D
(Percentage change between B & C). (Column D will be calculated from the 1st
data range, i.e. total lbs not stones and lbs).
However, i want Column C to be derived from the date range that shows the
weight in stones and lbs, and therfore looks throughout cells B18 to P26 and
return the entries below the latest date in the range. Below is an example of
how the data is laid out (1st version - in lbs):
July September
31/07/09 18/09/09 25/09/09
Andrew 142.75 - 140.75
Carol 130.5 131.5 126.75
Ewan 184.25 - 184.25
Joy 117.5 117.5 119.5
Jamesina 140.25 141.25 142
Kerry 150.5 - 134.75
Laura 150.5 151 151.25
Mark 201.5 205.25 202.75