Preserving formulas when using sort function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

If I have a two columns of data say, A and B and the are added together in
rows in Column C eg

A1 + B1 = C1
A2 + B2 = C2 etc

If I then move the contents of cell A1 and put it in say A23 the value of C1
does not change because the C1 become A23 + B1.

However, if I sort Column A then the value of C1 changes and the formula
appears to be wrong because it now takes the new value of cell A1

How can I make sure that when the sort takes place that wherever the value
in A1 ends up it is still added to B1 to create a value in C1?

Any help appreciated
 
If you use absolute references (ie $a$1) then the sort command will not
change the formulas
 
Back
Top