R
Roland
Am developing spreadsheet program that will allow one to
calculate impact of four variables with fixed unit values
to arrive at a net figure. However when all calculations
are done, using the ranking button on the net column to
sort lines low/high or high/low causes the spreadsheet to
display some very interesting and not believable values in
the intermediate fields, because their cell formulas are
now not in their original positions.
Is there a way to rank rows without causing this result?
Thanks for any responses in advance.
Roland
calculate impact of four variables with fixed unit values
to arrive at a net figure. However when all calculations
are done, using the ranking button on the net column to
sort lines low/high or high/low causes the spreadsheet to
display some very interesting and not believable values in
the intermediate fields, because their cell formulas are
now not in their original positions.
Is there a way to rank rows without causing this result?
Thanks for any responses in advance.
Roland