Returns the set of items common to both specified lists of values. The ordering of the results is based on how the items appear in the first list specified.
Intersection(List1:String,List2:String,Delimiter:String):String
List1 specifies a list of strings in which to search.
List2 specifies a list of strings in which to search.
Delimiter is the character to use to delineate items in the string list. Supported special characters:
[comma]
[space]
[tab]
Note: | You must use the name of the delimiter (not the character) and include brackets around the name. |
Intersection(A;B;C;D;E,C;E;F;A,[comma])
The return value is A,C,E.