one pedestrian way is to have anoter column which designates high as
A,medium as B and low as C. you can use <iffunction for this.
and then sort according to this new column


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.