| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy formula but keep table array a constant?
I am using Office 2003. I am referencing data from a pivot table as well if
this helps! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I copy formula but keep table array a constant?
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 --------------- Jacob Skaria "Damon" wrote: I am using Office 2003. I am referencing data from a pivot table as well if this helps! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I copy formula but keep table array a constant?
THANK YOU! I kept trying that but forgot the other $ sign! PHEW! Thank you
again! "Jacob Skaria" wrote: 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 --------------- Jacob Skaria "Damon" wrote: I am using Office 2003. I am referencing data from a pivot table as well if this helps! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a VLOOKUP into a column and keep a constant array? | Excel Worksheet Functions | |||
| Array Constant: How do I reference each value in a formula | New Users to Excel | |||
| Array, Formula, Constant, IF Statement Question???? | Excel Discussion (Misc queries) | |||
| Array formula with a constant? | Excel Worksheet Functions | |||
| array formula with constant | Excel Worksheet Functions | |||
Linear Mode
