Good day,
I have probably a common problem which I tried to solve with the offset formula but didn't succeed.
I have a dataset which is updated each week by adding a new column before the last one.
On the right there are formulas pointing to the last 3 columns respective the last 3 columns before the last 3 ones.
This principle should be kept.
This means: if I add a new column, these formulas should then shift by 1 column to the right and point again to the 3 last columns & 3 last columns before the last 3 ones. And so on, so dynamically whenever a new column is added.
Thanks for any help.
Best regards
Heinz
Bookmarks