sorting lists

L

Luc

Hi all,

I'm trying to sort a list of values of items, but i don't
want excel to pay any attention to numbers. The list is
of the form: 1 x case, 2 x pack of jumpers, 29 x pens,
etc. I want to sort the list alphabetically and not by
quantity. is this possible?

thanks for any help,

Luc
 
B

Bob Phillips

Luc,

You need to extract the sort value into an adjacent column, and sort both
columns with the extracted value as the key. Typical formula would be

=MID(A1,FIND("x",A1)+2,LEN(A1)-FIND("x",A1)+2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

Guest

Bob,

That worked a treat!

Thanks a lot,

Luc
-----Original Message-----
Luc,

You need to extract the sort value into an adjacent column, and sort both
columns with the extracted value as the key. Typical formula would be

=MID(A1,FIND("x",A1)+2,LEN(A1)-FIND("x",A1)+2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
Top