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

A quick way is to highlight the column with those values in and CTRL-H
(Find & Replace) as follows:

Find what: Low
Replace with: zLow
click Replace All

Now when you sort it will be in the order High, Medium and zLow, then
then you can use Find & Replace backwards to change the zLow back to
Low.

Hope this helps.

Pete

On Nov 5, 3:55*pm, MEGray wrote:
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?