Here's one way:
Say the words :High, Medium and Low Start in column C, Row1
then in column B , Row1: =IF(C1="High",1,IF(C1="Medium",2,3)) copy formula
down
This will give each word a number High=1, Medium=2 and Low =3
Now you can use scroll over the list Starting @ B1 and ending at the last
column, last row and select The sort Acending,or you can use a macro:

Sub PrioritySort()

Range("B1:C15").Select
Selection.Sort Key1:=Range("B1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub

There are certainly other methods out there, but this one will work for you
now.




"Aravind" wrote:

I have a column with priority list High, low and medium. I need to sort the
whole excel sheet according to that column. or priority list. Is it possible?
Can anyone give me advice.