Hi!

Use a helper column.

Assume D1:D100 contains entries of either High, Medium or Low.

In E1 enter this formula and copy down:

=MATCH(D1,{"High","Medium","Low"},0)

Then sort on column E ascending.

Biff

"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.