Forum Discussion
Relative reference not working with array formula in structured table
I have an array formula that works (structured table references). I need a mix of absolute and relative references but there is nothing I can do that seems to maintain integrity of a relative refger...
I had a similar issue where I used array formulas in the totals row of a table. The formula references the (corresponding) data column above each totals row cell. Dragging the formula from
Table[[#Totals],[Column1]] to e.g. Table[[#Totals],[Column5]] ends up with a formula in the latter cell that references Table[Column1]...not quite what I want!
For me, following workaround was acceptable: render the formula in a non-array formula and drag/copy it across. It behaved as relative references usually behave. Then I enter every cell and hit ctrl+shift=enter. Much faster than updating the references in every single formula!
HTH, Florian