CONTAINS checks if a case-sensitive substring/value exists in a string or array. Returns TRUE/FALSE (or custom TRUE/FALSE text labels for filtering).