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?
|