We need standard set operations in FileMaker. It can be replaced with custom function, but native function is always better.
- Distinct/Unique values
- TrimList - delete empty values
- Union / Intersect / Except
- Orderby - sort list asc/desc
- Where - filter list with condition - something like LINQ's Where(c => c.Value < 10)