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