Help! Excel 2010 is not sorting correctly

Take a look at this.
The table is automatic sorterd

Instead of =A2 etc, use this, copied down...
=INDEX($A$2:$A$8,MATCH(D2,$B$2:$B$8,0))

and instead of copy/paste values to get the data to sort, try his, copied down...
=SMALL($B$2:$B$8,ROWS($A$1:A1))

edit: must be an echo in here. popip used LARGE() to sort big to small, I used SMALL to sort small to big - take your pick

Hi guys, thanks for the quick responses. I guess my sample may not have been the best sample. In the main report, all the data is coming from other formulas.
I am attaching a much better sample. All the data is on the 'MTD By Account' tab, and I am trying to do sorting on the 'MTD By Upline' tab.

Excel Sorting issue sample1.xlsx
In column A we have the Items.
Column B uses this formula: =SUMIF('MTD By Account'!$A:$E,'MTD By Upline'!$A2,'MTD By Account'!$C:$C)
Column C uses this formula: =SUMIF('MTD By Account'!$A:$E,'MTD By Upline'!$A2,'MTD By Account'!$D:$D)
Column D uses this formula: =B2-C2
Column E uses this formula: =D2/B2

I am trying to sort by column E and keep everything aligned correctly.
The purpose is to sort the chart.

In the main report, all the data on the 'MTD By Account' tab is pulled from other sources using formulas. For this sample I have only included values.
This is a better example, after you sort you will see that some of the items are also moved, although still not aligned with the % or the cell ref in the formula. The %s are not even sorted in the correct order.
Before sorting:
Item Users Not logged in Logged in %
Item 1 847 231 616 72.73%
Item 2 937 40 897 95.73%
Item 3 176 25 151 85.80%
Item 4 257 4 253 98.44%
Item 5 264 5 259 98.11%
Item 6 34 20 14 41.18%
Item 7 21 1 20 95.24%

After sorting:
Item Users Not logged in Logged in %
Item 4 21 1 20 95.24%
Item 5 176 25 151 85.80%
Item 2 264 5 259 98.11%
Item 7 34 20 14 41.18%
Item 3 937 40 897 95.73%
Item 1 257 4 253 98.44%
Item 6 847 231 616 72.73%

Please post the example as a xls file

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Take a look at this.

excel doesnt like sorting formulas, seems it gets confused. I made a 2nd table... see if this will work for you?

Happy to help

Please use the thread tools near the top of the page to mark this thread closed

I'll throw this in. I've incorporated a drop down list for Large and Small, choose one and the sort accordingly as well as have Conditional Formatting for the values.