Custom sort list question

From: Hyun Yu (hyunyu_at_yahoo.com)
Date: 05/11/04 

Date: Tue, 11 May 2004 08:32:01 -0700

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.

Relevant Pages

  • Re: Which program is best to use for this task?
    ... have access to those programs at work and at home it would be personal time ... The form would be sent for the vendor to fill out all the information. ... We could open and print the form and attachments. ... some sort of database or something that would allow us some sort of tracking ...
    (microsoft.public.word.docmanagement)
  • Re: auto filter / sort
    ... the values will sort, ... I would like to be able to sort this master list into several vendor ... specific lists. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Help with Excel Query
    ... "Dave Peterson" wrote: ... > Vik wrote: ... >> What I want to know is how would I sort the data so that I could find out how ... >> many total contracts vendor X was given for example regardless of ministry? ...
    (microsoft.public.excel.setup)
  • Re: Link Access data to Intuit Quickbooks
    ... While waiting for Davids suggested qodbc.com to sort out their website, ... found another vendor, so I am posting this for the benefit of others or in ...
    (microsoft.public.access.externaldata)