Best/easiest way to determine if two columns in same dataset match

[orinocoworkflow]

I am using the email tool to compose emails (one email per record) and am having difficulty figuring out how to avoid CCing the same person as the email is to be sent to.

I want to compare two columns in the same dataset - "Email recipient" and "CC" and if they match, to make the CC column null so that email address isn't pulled into my email send. Is there a simple way to do this? Even a basic formula to create a Y/N column like if matches [A] and [B] then "Y"

This seems like it should be simple but I can't figure it out.

Thanks in advance for any help

[flying008 · Accepted solution]

Hi, @orinocoworkflow 

[CC] = IIF([recipient]= [CC],Null(), [CC])

[orinocoworkflow]

Ahh, thank you so much! I knew there had to be an easier solution than what I was finding.