How do I copy formula but keep table array a constant?

  • Thread starter Thread starter Damon
  • Start date Start date
D

Damon

I am using Office 2003. I am referencing data from a pivot table as well if
this helps!
 
Use absolute referencing. Below are the different reference styles.
A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

If this post helps click Yes
 
THANK YOU! I kept trying that but forgot the other $ sign! PHEW! Thank you
again!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array Constant 3
How can I change the source data reference to another pivot table? 2
Pivot Table range source area reference 1
2003 formula for Pivot 1
Pivot Table 2
constant in formulas 3
Pivot table copy and pasteing 2
Easy way to change Pivot table source files? 5

Back
Top