Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below List of Countries..
Data:
Load * Inline
[
Country
(Not Specified)
USA
India
UK
Germany
France
Canada
];
I want to create a List Box which will sort all Countries according to text format but (Not Specified) should come at last.
How to achieve this?
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.
-Rob