Ranking lines

[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

 

[Bob Phillips]

Roland,

Why not just sort all of the columns, not just the result column.