Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by "High", "Medium" and "Low"
Hi,
You need a helper column. Say you High, medium , low are in column A, put this in an empty column and drag down. =IF(A1="High",1,IF(A1="Medium",2,3)) Sort on this column and you can hide it if you want. Mike "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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by "High", "Medium" and "Low"
Tools - Options - Custom Lists tab
Type High Medium and Low into the List entries list box pressing rturn after each Click add and they will be added to the Custome lists listbox. Click the OK button. Now when you sort your data click on the options button and choose your new high, medium and low option from the dropdown box "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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by "High", "Medium" and "Low"
Thanks for responding Mike H. I've tried using your formula, and it works
for the Highs, but both the Mediums and the Lows are showing up as "3". I've modified the formula to account for where my data starts (I have headers), but can't figure out how to modify it to treat the Lows differently. =IF(C2="High",1,IF(C2="Medium",2,3)) Can you help? "Mike H" wrote: Hi, You need a helper column. Say you High, medium , low are in column A, put this in an empty column and drag down. =IF(A1="High",1,IF(A1="Medium",2,3)) Sort on this column and you can hide it if you want. Mike "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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by "High", "Medium" and "Low"
Hey RonaldoOneNil, thanks for responding!
I'm using Office 7, so I've gone to the Home tab, then clicked on Sort & Filter and then selected Custom Sort. I've added a new level (sort by = urgency, sort on = values and order = High, Medium, Low), but when I click OK, it doesn't resort my spreadsheet accordingly. I'm also not seeing my custom sort option -- I see Sort A to Z, Sort Z to A and Sort by Color. The Sort by Color option allows me to go to Custom Sort and I see my new level, but not sure how to select it. Any suggestions? "RonaldoOneNil" wrote: Tools - Options - Custom Lists tab Type High Medium and Low into the List entries list box pressing rturn after each Click add and they will be added to the Custome lists listbox. Click the OK button. Now when you sort your data click on the options button and choose your new high, medium and low option from the dropdown box "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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by "High", "Medium" and "Low"
I wanted to respond to my post, because your instructions actually worked, I
was using "Med" in my spreadsheet, but had set up a list to sort by "Medium". Thank you! Megan "MEGray" wrote: Hey RonaldoOneNil, thanks for responding! I'm using Office 7, so I've gone to the Home tab, then clicked on Sort & Filter and then selected Custom Sort. I've added a new level (sort by = urgency, sort on = values and order = High, Medium, Low), but when I click OK, it doesn't resort my spreadsheet accordingly. I'm also not seeing my custom sort option -- I see Sort A to Z, Sort Z to A and Sort by Color. The Sort by Color option allows me to go to Custom Sort and I see my new level, but not sure how to select it. Any suggestions? "RonaldoOneNil" wrote: Tools - Options - Custom Lists tab Type High Medium and Low into the List entries list box pressing rturn after each Click add and they will be added to the Custome lists listbox. Click the OK button. Now when you sort your data click on the options button and choose your new high, medium and low option from the dropdown box "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |