0

I have an excel table that has a list of measurements and dates those measurements were taken. Each measurement is from a specific location. I need to perform a series of calculations that are based on the previous date. In the attached, the columns I need help with are in bold:

Amt_Used: Amount in date "x" from location "a" - amount in preceding date from location "a"

Time_Diff: Number of days between date "x" and preceding date.

Per_Day_Use: Amt_Used / Time_Diff

Remaining_Days: Amount from date "x" / Per_Day_Use

Date_Empty: Date "x" + remaining days

Image of data

3
  • 2
    Please share the Formula you have tried so far, help us to understand the issue!! Aug 1, 2019 at 7:21
  • It sounds like you have three fields that we can call Value, Date, and Location. For a given row, you want to find the most recent previous date from the same location and then do math on those values. Can we assume the data is in order by date? (I.E., do we need to find the most recent data or can we just find the last row above the current row?) If the dates are in order, take a look at this question to find the last instance of a value in a column. Aug 1, 2019 at 20:23
  • Could you send a sample here?
    – Bella
    Aug 2, 2019 at 10:13

0

You must log in to answer this question.