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.

cj21 wrote:
>
> 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
>
> --
> cj21
> ------------------------------------------------------------------------
> cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
> View this thread: http://www.excelforum.com/showthread...hreadid=508070

--

Dave Peterson