Comparison with y-1, results from last year



I'm trying to build a module, where we compare the results with the results of one year earlier. Whey we change the year or date, the columns highlighted in yellow, should automatically show the data from one year earlier.

How can I do this? Using a formula?



  • Use offset formula. Below is the syntax:

    OFFSET(Value to offset, Offset amount, Substitute value)


  • Hi,

    Could you provide us some detail why you have rejected @Umang Singhal 's answer?

  • @Kris B,

    You can also use a lookup function. Go to SYS: Time Settings by Year Module and line item with formula ITEM(Time) - 1 and use that as lookup in your main module.