=LISTDIFF

The =LISTDIFF() function returns all items from the first semicolon-separated list that are not present in the second list.

Syntax

=LISTDIFF(SemicolonSeparatedList1; SemicolonSeparatedList2)

Parameters

• SemicolonSeparatedList1:
  The primary list from which items will be retained if they do not exist in the second list.

• SemicolonSeparatedList2:
  The list of items to remove from the first list.

How It Works

• Compares each item in the first list against the second list

• Removes any items from the first list that are found in the second list

• Returns a semicolon-separated list of remaining items

• Works with both field tokens and static text lists

Usage Notes

• Formula functions are case sensitive and must be in ALL CAPS

Example

If the List A field contains:

Entry1; Entry2; Entry3

and the List B field contains:

Entry2; Entry3; Entry4

then:

=LISTDIFF([[Field: List A (Text)]]; [[Field: List B (Text)]])

Result:
Entry1

---

Keywords

LISTDIFF, list difference, remove items, semicolon list, list comparison, text functions, formula function, calculated value