The second half of Biff's explanation is exactly what is happening in my
formula, since we are both using the same function (Lookup).
However, I just arbitrarily used a very much larger number then he did (99
to the 99th power) since this will usually fit *all* conditions.

Also, I didn't include an error trap for missing data as he did, since I
felt that an error message (#N/A) would be a fitting notification that
*something* was missing.

I thought that a "0" should signify "0" weight loss, and a null ( "" - empty
cell ) wouldn't really mean anything, since I presumed that the formula was
*not* going to be copied down a column.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Kath" wrote in message
...
Thanks Ragdyer - I don't suppose you could explain to me how that works
could
you? just so that I know why to do it this way again in future.

thanks

"Ragdyer" wrote:

Say your starting weight was entered in A1, and each new weight was
continually entered in the next empty cell in Column A.

Try this formula in B1:

=A1-LOOKUP(99^99,A:A)

--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Kath" wrote in message
...
I am creating a spreadsheet that will record weight gained/lost and I
have
the basic spreadsheet done.

However, I need to have a cell that returns a value equal to the
difference
between the starting weight and the most recent weight - which is not
necessarily the lowest weight, so I can't use MIN()

Values are being added every few days and as such Excel needs to update
as
needed each time. All weight data is entered within the same column.

Has anyone got any advice please.

Thanks.