quick filter

[cj21]

I have a list of product codes e.g

01
02
03
04
05
06
07
08
09
10
01a
01b
02a
02b
02c
02d
03a

I want these arranged as follows

01
01a
01b
02
02a
02b
02c
02d
03
03a
04
05
06
07
08
09
10

Is there a quick filtering method to do this?

Thankyou for oyur help

Chris

 

[flummi]

The question has been discussed a while ago, but I can't find the post.

So, easy way is:

In B1 enter '01',
In C1 enter 'a'
In A1 enter =B1&C1 which gives you your original combined product no.
Copy down as far as needed.

Then highlight the rows to sort and data-->sort by col B and then col C

 

[Dave Peterson]

Put this in B1:

=LEFT(A1,MIN(MATCH(TRUE,
ISERROR(-MID(A1&"x",ROW(INDIRECT("1:"&LEN(A1)+1)),1)),0))-1)

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

and this in C1:
=MID(A1,LEN(B1)+1,255)

Then sort your data by columns B and C.