By using an INDEX() or RANK() calculation this is possible to sort.
I attached the solution workbook as well!
Hope this helps!
that's cool, thanks for your help.
Glad that it helped you.
Thanks for the solution.
Can you please tell me if it is possible to make State collapsible into Region (like via a Hierarchy) and still maintain the same sorting logic ?
I am basically after the same result as in your solution, only with the ability to collapse "State" under "Region" with a +/- button.