| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
I have a column that contains priority levels for jobs - high, meduim, and
low i want to be able to sort these by priority do it goes HIGH MEDIUM LOW However when i try to sort it puts it in alphabetic order i.e HIGH,LOW,MEDIUM how can i get around this?? cheers |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting
Hi,
Assign a value to these (1=High,2=Med & 3=Low) in a column and sort on this new column which you can hide. Mike "Gazz_85" wrote: I have a column that contains priority levels for jobs - high, meduim, and low i want to be able to sort these by priority do it goes HIGH MEDIUM LOW However when i try to sort it puts it in alphabetic order i.e HIGH,LOW,MEDIUM how can i get around this?? cheers |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting
cheers,
so simple should have thought of that myself really "Mike H" wrote: Hi, Assign a value to these (1=High,2=Med & 3=Low) in a column and sort on this new column which you can hide. Mike "Gazz_85" wrote: I have a column that contains priority levels for jobs - high, meduim, and low i want to be able to sort these by priority do it goes HIGH MEDIUM LOW However when i try to sort it puts it in alphabetic order i.e HIGH,LOW,MEDIUM how can i get around this?? cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
| Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
| Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
| Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
| Sorting | Excel Worksheet Functions | |||
![Gazz_85[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
