Pages

21 October, 2023

offset formula / dynamic range in Google sheets

I need to set a dynamic range/offset formula in order to track only the last 5 inputs in to separate fields (for each person). Each month I am adding 1 new row for each person (2 new rows in total), so the range of the last 5 inputs should be updated.

No comments:

Post a Comment

Thanks