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.


Grd wrote:

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

--

Dave Peterson