ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting (https://www.excelbanter.com/excel-discussion-misc-queries/235905-sorting.html)

Gazz_85[_2_]

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

Mike H

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


Gazz_85[_2_]

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