Topic: EXCEL sorting with saving of formulas
There is here such label:
,A, B, A C, D, E
1, , in days, date ., date a game., the total
2, Ivanov, 4,43132, =C2+B2,100
3, Petrov, 2, =D2+1, =C3+B3,300
4, Sidorov, 7, =D3+1, =C4+B4,200
Essence of formulas that is set in days, the period beginning (it is anchored to the termination of the previous period + one day) and the period termination (the period beginning + set in days)
Prompt how correctly to do sorting that the binding of formulas remained on a place?
For example, if to sort across the field the Total that Sidorov's date started remained it is anchored to Petrov's expiry date.
Now at sorting all formulas remain on places. If before row number to add a sign "$" (D$2+1) as all formulas remain on places.
And it is necessary, that at formula sorting were moved after the line, as well as all remaining data this line.