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" wrote in message
...
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.