HI - I need to be able to drag a formula DOWN a column and have the formula increment the COLUMN reference but freeze the ROW reference.
So the formula in A1 reads =B1
I need A2 to be =C1
I need A3 to be =D1
I should know how to do this but it is escaping me...