Thanks Earl! That's exactly what I needed without having to create new
"helper" columns.

"Earl Kiosterud" wrote:

> Melissa,
>
> Make a custom list (Tools - Options - Custom Lists. Into the List entries
> box, type: High, Medium, Low separated by commas as shown. Click Add, OK).
> Now when you sort (Data - Sort), use the Options button, and open the First
> key sort order box, and select your list.
> --
> Earl Kiosterud
> www.smokeylake.com
>
> "Melissa" <Melissa@discussions.microsoft.com> wrote in message
> news:C11A3662-264D-40C2-99D7-4F2EECABB876@microsoft.com...
> > I've got 3 values: High, Medium, Low. How can I sort my table by all
> > "High"
> > items first, followed by "Medium" items, then by "Low" items? I can't use
> > alphabetical sorting coz either ascending or descending order won't work.
>
>
>