Get "current weight" when the column is not known?

[Rick B]

I have a spreadsheet with dates across the top and a daily weight entered
under the appropriate date.

I'd like to have a cell near the top of my spreadsheet that shows the
beginning weight minus the most recent weight. How can I tell it to grab
the right-most cell with an entry in it?

Thanks!

 

[Guest]

Assuming...
Your Dates are in Row 7, and increasingly larger to the right
Your Weights are in Row 8
You only enter a Date when you enter a Weight, (no dates in advance)
Your starting Weight is in A8

Put this formula somewhere above the data in row 1-6

=A8-HLOOKUP(MAX(7:7),A7:Z8,2)

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

=INDEX(1:1,MATCH(9.99999999999999E307,1:1)) for row 1

 

[Guest]

or, maybe........

=INDEX(MATCH(MAX(7:7),7:7),1,0)

Vaya con Dios,
Chuck, CABGx3

 

[Sandy Mann]

Or just for variety:

=A8-LOOKUP(9.9999999999999E+307,B8:O8)

--
HTH

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

Sorry, don't know what got in to me here............ignore this version and
use the formula in my first post.......it works.

Vaya con Dios,
Chuck, CABGx3