Sorting

G

Gazz_85

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
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top