![]() |
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 |
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 |
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 |
All times are GMT +1. The time now is 07:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com