markstro
Board Regular
- Joined
- Sep 8, 2008
- Messages
- 106
Excel sorts by number placement, first digit, then by the second and so on. All part numbers starting with a one are sorted first, if the second digit is a one also, the next sequence will be all numbers with 11 as the first two digits so on & so on.
Is there any way to set the criteria to sort part numbers with 3 numbers first, then 4 numbers second, 5 numbers third etc.
Questions on my question, hoped I worded it well enough to give you an idea of what I am trying to do.
Is there any way to set the criteria to sort part numbers with 3 numbers first, then 4 numbers second, 5 numbers third etc.
Questions on my question, hoped I worded it well enough to give you an idea of what I am trying to do.