how to identify

[hi2019]

I want to identify any , inside the Payee name column - would that be a fomula? or filter?

I would like to create a column with these so I can then create another formula that has comma, plus other things to have them filter out to another MAnual tab.

Example : 

If [Payee Name Count] = '1'
AND [ID Codes] != 'ENT'

AND ------------if payee name has commas

THEN 'Manual Review'
else [Sheet Name] ENDif

[BS_THE_ANALYST · Accepted solution]

@hi2019  If you're checking if cells within a column contain a comma "," then you could use the contains formula: Contains([field here], ",")

All the best,

BS