In my data range, Department is a variable. Now I want to sort data range by department but the order of sorting would not be ascending or descending. It should be as per given order.
Code Sales Department A001 1234 Sales A002 3456 Admin A006 4567 Ops A007 8956 Support A008 7895 HR
Now I want to sort above data range by department and order of sorting must be Ops, Support, HR, Admin and Sales. After Sorting data range must be look like.
Code Sales Department A006 4567 Ops A007 8956 Support A008 7895 HR A002 3456 Admin A001 1234 Sales
Please help to do this.