2 Replies Latest reply on Sep 8, 2016 10:49 AM by Alexander Mou

    First/last value in a time series

    Simo Tumelius

      Hi,

       

      so this is a question that has multiple solutions online but I haven't been able to get any of them to work for a time series. The problem is very simple: I have time series data (y,t) and I want to create calculated fields for the first and last y values in the time series.

      I've tried using INDEX(), LAST(), FIRST(), LOOKUP(), etc. but haven't been able to figure out how to get them to work properly.

       

      A sample workbook and two data files can be found in the attached .zip file.

       

      -Simo