Are all individuals weighed on the same date?

=SUMPRODUCT(--(Sheet2!$A$2:$A$500=A1),--(Sheet2!$B$2:$B$500=MAX(Sheet2!$B$2:$B$500)),Sheet 2!$C$2:$C$500)

Assumes:
A1 has your current sheet's trainee name
Sheet2 has your weigh-ins
Column a of Sheet2 has list of trainee names
Column B of Sheet2 has dates of weigh ins
Column C of Sheet2 has weights
There are less than 500 total rows in sheet2.

"carol" wrote:

Hi Mike,

Thank very much - that worked.

I have another problem to solve - perhaps you could help.

In column A, i have put the starting weight of everyone in the group. In
column B, I want to put the latest weight of the group. I therefore need a
formula that will look through the data range, pick out the latest date and
then populate the column with the corresponding weight from that date. Any
ideas?

Thanks

Carol

"Mike H" wrote:

Hi,

With pounds in A1 try this

=INT(SUM(A1)/14)&" Stones "&MOD(A1,14)&" Pounds "

Mike

"carol" wrote:

Does excell recognise weight in st and lbs? Iam trying to devise a weight
monitoring s/s that tracks the percentage gain or loss each week, but want it
to be shown in st and lbs not total lbs.

Thanks

Carol