Excel Table sort using cell references...

[Jimmypop]

Good day all

I have a Table1. Two Columns. The one columns has site names and the other columns has values inside them. These values are populated from a cell refreence on the same sheet e.g. =AI2...

Now my issue is when I sort the table values column from largest to smallest it only sorts the first columns (site names) and does not sort the values column (which come from the cell references)... Appreciate any assistance in this regard...

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Jimmypop]

This doesn't seem like good design to me, but you can include the sheet name in your formula link and it should then sort as you want.

This also works thanks... It might not good design but at the moment it is the only thing I can think of to try and reduce the size of a chart I am trying to create for a report. The person seeking the report wants it to be a Pareto Chart and from the amount of columns and data the Pareto is not showing correctly from highest to lowest... Now I realize that just selecting the data from my original table it would give me a high to low Pareto... however the manager does not want the pareto line he want a sort of "compliance line" whereby it is set as a target line for sites to achieve... So basically I have to do a column chart which goes from high to low with a target line in....

I am more thinking he is trying to see if I am going to say it can not be done and then with assistance from the forum then he is proven wrong

 

[RoryA]

Since you have 365, I'd imagine you could just use a SORT or SORTBY formula.