• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sorting Question

G@ines63

New Member
Hello All,
I am posting a question regarding the sorting of numbers in the following format:
1\1
1\2
1\3
2\1
2\2
2\3....and so on.
The issue I am having is, once the numbers reach 9\3, the numbers begin to sort as follows:
100\1
100\2
100\3...
I would like any input as to how to create a custom sort to keep the numbers in succession, i.e
9\1
9\2
9\3
10\1
10\2
10\3
11\1
11\2
11\3
12\1
12\2
12\3...and so on
Thank you in advance for any assistance.
 
I don't have a straight forward answer, but I have a workaround. Replace the \ with the . Now sought the value & again you can replace . with \
 
Split the numbers up in 2 seperate columns

'=LEFT(K2,FIND("\",K2)-1)

'=MID(K2,FIND("\",K2)+1,9)

Then sort all 3 columns after columns vith the first digit then the sekond digits
 
Back
Top