1 Reply Latest reply on Jul 1, 2016 3:43 AM by Yuriy Fal

    how to pick up a specific 'cell' value

    CHIN CHUAN GOH

      this is something like Offset function in Excel VBA.

       

      I would like to do a division where current value divided by the value in previous one row and previous one column (offset(-1,-1))

       

      Example: Below are the sales number

       

                          Jan     Feb     Mar     Apr

      group 1         5          10     12       15     

      group 2          6         11     18     14    

      group 3         4         8         7         6

       

      I would like to get the following result:

       

                          Jan       Feb         Mar         Apr

      group 1         5          10           12           15     

      group 2          6        11/5       18/10      14/12    

      group 3          4         8/6         7/11        6/18

       

      I have tried LOOKUP, First () or Last() but these are only reading the number of rows whereas I need both rows and columns.

       

      Also, how do I write a formula to read the date for a month before? It's like EDATE(start_date, months) function in Excel.