My organization has region codes which we use in everyday discussions, there is a history behind the region codes which has a numeric structure.  I need to sort my text based region codes according to their historic numeric indicator.

Region       number

RNA            1

RLA              2

REU              3

and so on.  I built an excel which holds this relationship but I cannot see how to sort the output.  I need columns in my bar graphs sorted this way, rows in my tables should be in this order, etc, etc.

Any suggestions?

thanks

donald

 

 or register to reply.

Notify Moderator