Hi Melissa

Use a helper column. Assume your data is in Column A starting in Row 2. In
row 2 in any unused column enter the fomula:

=IF(A2="High",1,IF(A2="Medium",2,3))

Copy this down to the end of your data. Then select all data and sort by
this new column ascending. The helper column can then be hidden.

Hope this helps
Rowan

"Melissa" wrote:

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.