Advanced Filter Criteria

When adding a filter, it is sometimes needed to add 2 separate ranges of values. For example, if I want to build a range list and filter by G/L No 50,000 to 59,999 OR 70,000 to 79,999, then there is no way of doing this currently within a single Cosmos function. An alternative way to acheive the same goal would be to have the <> filter with a range (instead of a single value). Either way would add more flexibility.