Sorting columns is calculating numbers in my text?
Sorting columns is calculating numbers in my text?
ChrisG
Posts: 29Questions: 0Answers: 0
I have columns with the following data:
4/5
1
5/5
2
5/5
11
How can I get it to sort ascending like this:
5/5
11
5/5
2
4/5
1
So basically it just sorts the first line alphabetically and the second line numerically. Thanks in advance. :)
4/5
1
5/5
2
5/5
11
How can I get it to sort ascending like this:
5/5
11
5/5
2
4/5
1
So basically it just sorts the first line alphabetically and the second line numerically. Thanks in advance. :)
This discussion has been closed.
Replies
Allan
So sort by the "4/5" text and then sort by the number below that. Is that possible?
Allan