I don't recommend that you use my workaround. Much better that you keep trying until you get this OrderCustom thingy to work, or that someone here explain it to you. But I've never needed to use it; consequently I can't be the one to help. So if no one here answers, and you can't figure it out yourself, it is possible if you're desperate to do this:
- Create a helping column to the right.
- Place in the helping column a set of values that correspond to the contents of col B, only in the correct order; that is, where B has a 2 put 1 in the helping column, where B has 1 put 2, and where B has 3 put 3.
- Sort by C and then by the helping column.
- Delete the helping column.
That'll work. But if you can figure out Excel's customized sorting you'll be 'way ahead of the game.