Probably another one of those "I'll kick myself for asking" questions, but: Does anyone have an elegant way (calculation or custom function) to remove "mostly matching" items from a list? Here's what I mean:
I want to remove all "gadget" items from the list. FilterValues() almost does it, if only I could wildcard it:
FilterValuesWild ( $myList ; "Widget *")
Similarly, a "negative" FilterValues() that returns everything NOT in the filter would be helpful, too.
Surely this isn't an off-the-wall request?