software

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: www.excelforum.com/member.php...oamp;userid=25673
View this thread: www.excelforum.com/showthread...hreadid=508070The 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 =B1amp;C1 which gives you your original combined product no.
Copy down as far as needed.

Then highlight the rows to sort and data--gt;sort by col B and then col CPut this in B1:

=LEFT(A1,MIN(MATCH(TRUE,
ISERROR(-MID(A1amp;quot;xquot;,ROW(INDIRECT(quot;1:quot;amp;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:
gt;
gt; I have a list of product codes e.g
gt;
gt; 01
gt; 02
gt; 03
gt; 04
gt; 05
gt; 06
gt; 07
gt; 08
gt; 09
gt; 10
gt; 01a
gt; 01b
gt; 02a
gt; 02b
gt; 02c
gt; 02d
gt; 03a
gt;
gt; I want these arranged as follows
gt;
gt; 01
gt; 01a
gt; 01b
gt; 02
gt; 02a
gt; 02b
gt; 02c
gt; 02d
gt; 03
gt; 03a
gt; 04
gt; 05
gt; 06
gt; 07
gt; 08
gt; 09
gt; 10
gt;
gt; Is there a quick filtering method to do this?
gt;
gt; Thankyou for oyur help
gt;
gt; Chris
gt;
gt; --
gt; cj21
gt; ------------------------------------------------------------------------
gt; cj21's Profile: www.excelforum.com/member.php...oamp;userid=25673
gt; View this thread: www.excelforum.com/showthread...hreadid=508070

--

Dave Peterson