Copy a Formula to Multiple Rows, but Keep One Column Ref in the Formula the Same?
I understand that when you copy a formula with criteria in certain columns to adjacent columns, it changes the column references to keep the relationship between columns the same (ie, column 10 has a formula that references col 1 & col 3, and copying the formula from col 10 to col 11 would result in the col 11 formula referencing col 2 & col 4)
Is there a way to keep a column reference as a hard reference no matter where it's place?
ie - Column 10 =Col1@row + Col3@row, Column 11 =Col2@row + [email protected] Col3@row reference never changes
Is there a symbol that can be put in front of it to always keep it there?
Help Article Resources
Check out the Formula Handbook template!