Re: Custom sort list question
From: Bernie Deitrick (_at_)
Date: 05/11/04
- Next message: Don Guillett: "Re: mass change of numbers to alphabetic"
- Previous message: Krish: "Wireless Keyboard"
- In reply to: Hyun Yu: "Custom sort list question"
- Next in thread: Hyun Yu: "Re: Custom sort list question"
- Reply: Hyun Yu: "Re: Custom sort list question"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 May 2004 11:45:34 -0400
Hyun,
You're correct, that custom lists can only be used as the first sort key.
You will need to add a helper column with a sort order for the component
column. An easy way is to copy the Component column to the new column, then
do a successive replace to change the component type to numbers for sorting.
HTH,
Bernie
MS Excel MVP
"Hyun Yu" <hyunyu@yahoo.com> wrote in message
news:2gc9viF15qnnU1@uni-berlin.de...
> I have a table with the following columns: Vendor, Component, Purchase
> Date, Price.
>
> All entries in the Component column are in one of the following five
groups:
> "Processor", "Memory", "Video Card", "Hard Drive", and "Power Supply".
>
> What I'd like to do is be able to sort the table by Vendor first, then by
> Component, but in the following order for Components: "Processor",
> "Memory", "Hard Drive", "Video Card", and then "Power Supply". Obviously
> that list is not in alphabetical order. Is it possible to specify a
> customized sort list? I've looked in Excel (2003) help, and it mentions
> using a custom list, but that only seems to work when the cell being
sorted
> with the custom list is the first in the "Sort by" dialogue (in my case,
> "Vendor").
>
> Thanks for any help.
>
>
- Next message: Don Guillett: "Re: mass change of numbers to alphabetic"
- Previous message: Krish: "Wireless Keyboard"
- In reply to: Hyun Yu: "Custom sort list question"
- Next in thread: Hyun Yu: "Re: Custom sort list question"
- Reply: Hyun Yu: "Re: Custom sort list question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
