I have a data base with two columns, one has a list of players names The other a number of points they have. I would like to sort them by the number of points. When I highlight the two columns and choose “Data, sort to ascending” it sorts the point column ok but also sorts the names alphabetically. I need the manes to stay with the point values. Is there a way to do that, please.
You need a contiguous range to sort.
I presume your columns are separated by at least one blank column. Either remove the blank column(s) or give it (them) a title or something so they form part of the range to be sorted.
In the sample, SortDataByPoints106799.ods, if I click in the points column and click Data > Sort ascending then the names will sort to stay with the points. If I remove the title Random then the Points will sort independently of Names.
SortDataByPoints106799.ods (18.1 KB)