Thread: Custom Sorting
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline
external usenet poster
 
Posts: 1,071
Default Custom Sorting

Yes. You would need VBA (programming) for that. Basically, the VBA would
build an extra column with numbers that would subsequently be used to sort
by. One question, though. Say that you have a group of numbers that ALL
started with, say, 2. How would you want that group sorted? Not sorted
within the larger group of all numbers, just within that one group. HTH
Otto
"A. Roger" wrote in message
...
Hello,
I have an inventory sorted by ascending part numbers(smaller to largesr).
But i would like for the order to start with numbers that begin with a 0
then
with numbers that start 1 and so on, regardless if the number is smaller
or
bigger.

Is this possible?