Sep 04 2017 08:15 PM
Sep 05 2017 12:53 AM
Thomas,
Assuming I understood the challenge you're dealing with... that's how Excel behaves with regard to absolute vs. relative references. In your example A1 is a relative reference re. row (A) and column (1) numbers.
If you don't want the row number (A in your example) to change during a copy/paste operation (or other calcs) add a $ sign before A ($A1). $A1 is a reference where the row number is Absolute ($A) and column number (1) is Relative.
Same logic for the column number. If you want it to be Absolute add a $ sign before the 1 ($1). $A$1 is a reference where both the row and the column number are Absolute.
Finally you can have ref A$1 where the row number (A) is relative and the column number ($1) is absolute