AnsweredAssumed Answered

I need a calculation to find the most RECENT entry - not the highest or lowest value

Question asked by KimSmith on Sep 25, 2013
Latest reply on Sep 25, 2013 by philmodjunk

Title

I need a calculation to find the most RECENT entry - not the highest or lowest value

Post

     I'm putting together a database to track a weight loss challenge. I have fields that read  "initial weight" , "week 1" , "week 2" etc, all the way up to "week 12". I want to be able to input the weights each week into a field, and then have a separate field show what their "current weight" is. Keeping in mind most people yo-yo a bit on their weights, so it won't necessarily be the lowest value. What calculation should I put in the "current weight" field for this to show up? (..in excel I used an INDEX /MATCH function).

Outcomes