sorting

  • Thread starter Thread starter kkrkeith7
  • Start date Start date
K

kkrkeith7

Im having trouble sorting a column of percentages. The cells in column
are cell referenced (=B5) and B5 is a formula (A2/A1-1) When I try t
sort, the data just flashes and goes back to what it originally was. I
highlighting only column F because I dont want any other column
sorted. Any help??:rolleyes
 
It's because you're only sorting that column. Once you
sort, the formulae will recalculate, leaving you right
back where you started.

You'll have to either sort the whole area including the
values which the formulae work on or Copy > Paste Special
Values which will then allow you to sort the percentages.
Click to expand...

Cheers, Pete
 
Back
Top