E
evemonkey
I am trying to sort a column of formulas that consist of cel
references. Example:
Column:
Cell 1 holds: =D10
Cell 2 holds: =D11
Cell 3 holds: =D12
Data:
D10=1
D11=2
D12=3
When I try to sort the column of formulas, the formulas change cel
references to other cells and mess up the data.
How can I sort a column of cells of which all of them contain formula
and have the cells keep the references to the right place
references. Example:
Column:
Cell 1 holds: =D10
Cell 2 holds: =D11
Cell 3 holds: =D12
Data:
D10=1
D11=2
D12=3
When I try to sort the column of formulas, the formulas change cel
references to other cells and mess up the data.
How can I sort a column of cells of which all of them contain formula
and have the cells keep the references to the right place