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...
Please see detailed guide on Excel table Structural references both relative and obsolete.
Unfortunately, this was not helpful. I do not have a problem with absolute references. The problem is that if I leave things as a relative reference, they do not behave as such with copying / pasting (or dragging) across to neighboring rows. I need need the reference to maintain a relative nature in an array formula. It seems the array formula changes how these things behave.