The opposite of FilterValues()

[Matt Klein]

OK, I am probably going to regret posting this, but it's the end of the day and I'm fried and I figure one of you guys or girls will be able to answer this before I can figure it out tonight......

Let's say I have a field(Field 1) with a list of items:

1

2

3

4

Now let's say I have another field(Field 2) with values in it:

1

3

Now let's say I want to return all the values in Field 1 that don't appear in Field 2. How would I go about doing that?

FilterValues(Field1; Field2) will return those values in Field 2 that DO appear in Field1. I'm looking for just the opposite.

[comment]

You'd need a custom function for this.

See also the discussion here:

http://fmforums.com/forum/showtopic.php?tid/187248/

[Matt Klein]

Thanks comment