sorting lists

  • Thread starter Thread starter Luc
  • Start date Start date
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
 
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)
 
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...
 
Back
Top