FilterValues - show difference

[Ballycroy]

The FilterValues function shows returned-delimted items that are common to both lists in 2 different fields:

FieldONE

John

Sam

Gordon

FieldTWO

John

Sam

FilterValues(FieldONE; FieldTWO)

Returns

John

Sam

[color:green]Question:

How do I get the difference:

Gordon

[The Shadow]

Here's a custom function for it:

http://www.clevelandconsulting.com/support/viewtopic.php?t=120

[mr_vodka]

If you want the items that are not common in both lists then try this custom function.

XORValues CF

However, If you want to remove the items listed in List B from list A, then try this Custom Function

ZapValues CF

[Ballycroy]

Thak you both for the links