Need to port COUNTIFS + other Excel logic to Alteryx

[SalazarBurt]

Hi! I have spent upwards of 10 hours trying to convert the following excel logic into Alteryx formulas, but have made 0 progress. I would be absolutely indebted for any help in this:

=IF(AND(COUNTIFS($C$2:$C$500,C2,$N$2:$N$500,[column name])>0,N2<>[column name]),1,0)

The objective is that I have a dataset of ~70L rows, and I need to fill a column, with this formula. The cells C2 & N2 refer to others columns in the same row, whereas C2:C500 & N2:N500, refer to two full columns in my dataset. Happy to provide any further information that's needed. 

Thank you in advance, for any help or brainstorming on this. 

[rzdodson]

@SalazarBurt would you be able to provide a useable data set here? I think I can help you out here.

[caltang]

Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.