Hi Phil, With respect, I think you're wrong. I experimented by creating the same formula referencing the same data table, with one version using relative references and a second version using absolute references. When I moved one of the data columns with the mouse method, both formulas continued to display the same and correct results. However, when I copied and pasted the data column to the new location both formulas displayed formula errors.
Maybe this depends on the types of formulas you're using. Why don't you experiment and see. I'd be interested in hearing your results. The more I know about Numbers the better for me. On 8 Aug 2014, at 11:14 pm, Phil Halton <[email protected]> wrote: > Regardless of the method you used to move a column, the formulas contained > there in will be affected. The addressing method holds whether you copy and > paste the formula or whether you drag-and-drop it, or whether you use some > other method. Regardless of how you move it, if there is relative or absolute > addressing conflicts, the formula will be negatively affected. > > Sent from my IPhone -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
