Match returns the number of the element that matches, zero if no match.So for:
match(Country,'(Not Specified)')
If Country = '(Not Specified)', the match returns 1. For all other Country values it will return 0. So the 0 values will be sorted first, followed by the 1 value. The multiple 0 values will then be sorted by the secondary sort of Text.
Please mark an answer as correct if you have a solution.
