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! |
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! |
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! |
All times are GMT +1. The time now is 11:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com