sorting

[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

 

[Pete McCosh]

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.

Cheers, Pete

 

[kkrkeith7]

Thanks! Paste Special worke