• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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?
 
Top