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

R

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!
 
C

CLR

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
 
C

CLR

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
 
Top