Hi,

What I'd like to do is to detect if there are other string values in a column other than in the selection of strings in a range.

Example data:

Range Selection (A18:A27)
Name 1
Name 2
...


Column S
Name 1
Name 1
Name 2
Name 4
Name 2
Name 3
...

Output 1
True = if all text labels in Column S are equal to text labels of Range Selection
False = if there are text labels in Column S that do not appear in the Range Selection

Output 2
Provide an overview of the names that are in Column S that are not in the Range Selection

Let me know if you need more information,

Jeroen