Ranking lines

  • Thread starter Thread starter Roland
  • Start date Start date
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
 
Back
Top