Relative column references

Comments

2 comments

  • Joel Stewart

    I'd recommend pivoting the data using the GROUPSELECT function first. Then you could utilize the GROUP_PREVIOUS function in a later sheet to be able to reference an ordered list of the records and the previous one to it. With this data, you could easily subtract one column from the other. If required, you could use GROUPSELECT again to pivot the data back.

    The approach of repeating the functions for cells avoids having to pivot the data first to use GROUP_PREVIOUS. Both options will work technically, it's just a matter of which is more efficient for your scale. 

    0
    Comment actions Permalink
  • Venkata Praveen Pingali

    Thanks Joel!

    0
    Comment actions Permalink

Please sign in to leave a comment.