# how to sort column of numbers generated by a formula

#### traehegdirb

##### New Member
in column A I have a list of numbers

in column B I have a formula which calculates the percent change in the numbers from one row to the next.

I want to then sort the resultant numbers in column B

Excel will not sort that list of results.

A B

[pre]
Code:
``````1    32
2    16     =sum((A2-A1)/A1)*100
3    32     =sum((A3-A2)/A2)*100
4    64     =sum((A4-A3)/A3)*100
5    32     =sum((a5-a4)/a4)*100``````
[/pre]

Column B2 will display the number -50

Column B3 will display the number 100

Column B4 will display the number 100

Column b5 will display the number -50

I now want to sort column B ascending

It should sort and display the following results in column B:

-50

-50

100

100

Instead, when I do the sort routine for column B, nothing changes in column B.

What Am I doing wrong?

#### traehegdirb

##### New Member
sorry..my first post had a typo listing the wrong order of the results. the second one is the correct one.

#### Hui

##### Excel Ninja
Staff member
Traehegdirb

Copy and Paste as Values Column B

Then Sort

#### traehegdirb

##### New Member
Thanks to Hui !!!

This worked perfectly..should have thought of it myself, but needed just a little expert advice.