View Single Post
 
Old 04-15-2016, 05:38 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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:
  1. Create a helping column to the right.
  2. 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.
  3. Sort by C and then by the helping column.
  4. 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.
Reply With Quote