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