How to do a peculiar sort?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm trying to sort a Ratings column which has entries of Low, Medium and
High. However an alpahbetic sort doesn't work out as I would like them in a
certain order. Is this possible? Its driving me crazey cos I get High, Low,
Medium.

Any help greatly appreciated.

Thanks in advance

Georgina
 
Insert a helper column. In the helper column type in and copy the formula -

=IF(A1="high",1,IF(A1="low",5,IF(A1="medium",9,)))

The actual value is significant ONLY that it is in the order you want to
sort AND that there is a gap so that you can alter the running order without
too much amendment.

Use this column to sort your data.

Regards.

Bill Ridgeway
Computer Solutions
 
I'd just use another column and put 1, 2, 3 in there and sort by that.

=if(a2="high",1,if(a2="Medium",2,3)))

(to get my 1,2,3's.)

=====



But you could define a custom list.
tools|options|Custom list tab
type High,Medium,Low

Then when you sort, use:
data|sort|options Button and select your custom list.
 
Use a helper column to assign 1 to Low, 2 to medium, and 3 to high.......then
sort on that column

=IF(A1="LOW",1,IF(A1="MEDIUM",2,IF(A1="HIGH",3,""))) and copy down, replace
A1 with your appropriate cell address.


Vaya con Dios,
Chuck, CABGx3
 
Niek said:
Hi Georgina,

Tools>Options>Custom lists

Read HELP for details
Click to expand...
Just wanted to add that once you make a custom list
Under SORT you need to go to options and select it as the sort order

Dont forget to reset it back to normal

George
 
Back
Top