How to define my own raising type of sequence

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Konrad Den Ende - 06 Jul 2004 03:15 GMT

I have a chart that is supposed to be sorted with respect to the
values in the first column. The problem is that those values are
not alphabetically raising.

Suppose the values are "great", "well", "ok", "bad". How can i get
Excel to understand that the right raising sequence is "g, w, o, b"?

Signature

Kindly
Konrad
---------------------------------------------------
May all spammers die an agonizing death; have no burial places;
their souls be chased by demons in Gehenna from one room to
another for all eternity and more.

Sleep - thing used by ineffective people
as a substitute for coffee

Ambition - a poor excuse for not having
enough sense to be lazy
---------------------------------------------------

Reply to this Message

DDM - 06 Jul 2004 04:39 GMT

Konrad, first create a custom list. Tools > Options > Custom Lists > New
List. Type the list entries in proper order (great, well, ok, bad). Click
Add, then OK.

Next, sort your data using your custom list. Click in the data and Data >
Sort. Under Sort by: select the column and select Ascending. Then click
Options. Under First key sort order: select your custom list. Select Sort
top to bottom, then OK, OK.

Signature

DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

> I have a chart that is supposed to be sorted with respect to the
> values in the first column. The problem is that those values are
> not alphabetically raising.
>
> Suppose the values are "great", "well", "ok", "bad". How can i get
> Excel to understand that the right raising sequence is "g, w, o, b"?

Reply to this Message

Konrad Den Ende - 08 Jul 2004 02:40 GMT

> Konrad, first create a custom list. Tools > Options > Custom
> Lists > New List. Type the list entries in proper order (great,
[quoted text clipped - 4 lines]
> Ascending. Then click Options. Under First key sort order:
> select your custom list. Select Sort top to bottom, then OK, OK.

Yes, that's working if the custom list is the primary key of
sorting. However, if it's placed second, it goes back to the
alphabetical order. So if i try to order after (1) quality and
then (b) after chapter number it's all right. But as soon as i
try to get the (1) chapter number and then (2) quality within
the current chapter, i can't make Excel sort the data according
to my custom list. Is it a bug or did i miss something?

Signature

Reply to this Message