Notifications
Clear all
Topic starter
How do I define a fix for a column based on a dynamic table? The attachment contains a formula based on a dynamic table and when I draw the formula to the left the column moves - how do I fix it?
Posted : 31/01/2019 2:16 pm
Hi Lea,
There's no file attached. You need to press the yellow 'start upload' button to complete the file upload.
That said, this post explains how to make Table references absolute.
Mynda
Posted : 31/01/2019 7:36 pm
Topic starter
Hi
Attached File
I would be happy to receive a focused response, thank you
Posted : 01/02/2019 12:36 am
Hi Lea,
It will be time well spent to read the tutorial because there are other nuances not covered in this answer:
=SUMIFS(data[[sum]:[sum]],data[[platoon]:[platoon]],$F2,data[[year]:[year]],G$1)
Mynda
Posted : 01/02/2019 12:47 am
Topic starter
Stunning! A strong answer, thank you !!!
Posted : 01/02/2019 2:53 am