Problem with Sorting rows on a column

Hi All,

I have a peculiar problem and have scoured the forums and all over Google to find the answer. The problem is that I'm trying to sort rows based on a column value simple as it sounds - I have tried the obvious thing by sorting A-Z and expanding the selection to include the whole table, and also using a filter on the whole table and sorting it A-Z, however its seemed to do 95% of the sort correctly as the last values in the last column seems to have failed to sort properly. I have 14 columns in the spreadsheet and there are over 300 lines. There are no formulas and all values are literally numbers. Can someone please advise how to fix this. Many thanks in advance.

This is what I mean:

To sort:

B 1 5 4 3

A 5 2 3 5

C 2 1 5 4

Result:

A 5 2 3 [3]

B 1 5 4 [4]

C 2 1 5 [5]

Hi FDibbins,

Thanks for such a prompt reply. That was more of a simplified explanation of real problem. I really should have stated that. The problem occurs in this .xsl file (attached), currently its unsorted.

That is correct. What happened was the very last column would not follow the sort. I wonder how it worked for you? Cheers

Originally Posted by FDibbins

and you want to sort the entire table based on column A?

If so, whe you have done that, what have been the errors?