I'm going to try and do this on the fly.
copy these formulas down each column to the bottom of the data.
Column D formula: "=If(Search(0,A1)>0,"0","1")"
Column E formula: "=If(Search(1,A1)>0,"0","1")"
.....
Column M formula: "=(Search(9,A1))>0,"0","1")"
Column N formula: "=D1&E1&F1.....&M1"
This will producet these results in column N
Then when A1:N1000 is sorted on column N all the same digits will be together.
(013 produces same as 310, 657 produces same as 756)
It's not perfect, but it does group them together (555 will be after 756).
If you need 555 to be before 756, it can probably be done, but I'd have to think about it.
Bookmarks