View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MEGray MEGray is offline
external usenet poster
 
Posts: 4
Default Sorting by "High", "Medium" and "Low"

I'm trying to sort the rows in my spreadsheet based upon their priority -
High, Medium or Low. I can sort them so that all the Highs are grouped
together and then the Lows and then the Mediums, but I want the Highs listed
first and then Mediums and then Lows. Right now I can only figure out how to
sort alphabetically A to Z or Z to A.

I've tried the custom sort, but can't seem to get it to work.

Can anyone help?