Enter your list in a column, in the sort order you're looking to create.
Then select the entire list, then.
<Tools <Options <CustomLists
Since your list is already selected, just click on the "Import" button, then
<OK.
Now, when it comes time to sort, click the "options" button in the Sort
window,
Choose your list in the key sort window,
Then <OK <OK
Since the "CustomList" can only be used for the first sort key, you'll have
to repeat the sort process as many times as you have sort orders, and you
must do them in reverse, from minor to major.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Slabtamer" wrote in message
...
I am trying to sort faculty records by position in Excel and am having
some
trouble. The usual sort options don't seem relevent, so I have a hunch
that I
need to configure a custom list. I would like the records to appear in the
following order: Full, Associate, Assistant, Instructor. If anyone could
shed
some light on this for me, I'd be greatly appreciative. Thank you.
|