Sort - Not Alphabetical

[Guest]

Hi,

I have a list of tasks with main headers. I would like the tasks sorted by
main header, but not alphabetically. For instance:

Miscellaneous Data
Distributions
Impact Model
Asia Items

Currently I can only sort so that the list ascends or descends
alphabetically. Is there a way for me to specify that items with value A in
column A go first, items with value B in column A go second, and so on?

Thanks,
Tom

 

[Niek Otten]

Hi Tom,

Tools>Options>Custom lists

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| I have a list of tasks with main headers. I would like the tasks sorted by
| main header, but not alphabetically. For instance:
|
| Miscellaneous Data
| Distributions
| Impact Model
| Asia Items
|
| Currently I can only sort so that the list ascends or descends
| alphabetically. Is there a way for me to specify that items with value A in
| column A go first, items with value B in column A go second, and so on?
|
| Thanks,
| Tom