Formula help for a two-column match / mismatch

[rogaret]

I thought I was on the right track, but have messed it up somewhere.

Sorting based on a match in column C was easy enough, and then I could go down and visually pick out where I had a mismatch in column D. Tried to get a formula in E that would just return a YES in the highlighted rows.

=IF(COUNTIF($C:$C,C2)=1,"",IF(COUNTIFS($C:$C,C2,$D:$D,D2)=COUNTIF($C:$C,C2),"","Yes")) does NOT work, but I think it may only need some minor change to do so...




[TABLE="width: 579"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Rep[/TD]
[TD]Customer[/TD]
[TD]Order Num[/TD]
[TD] Due Date[/TD]
[TD]No Match[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]0507075687[/TD]
[TD] 12/12/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]0507075687[/TD]
[TD] 12/12/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]0508231008[/TD]
[TD] 12/7/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]0508231008[/TD]
[TD] 12/13/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]0508780590[/TD]
[TD] 12/13/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]0508780590[/TD]
[TD] 12/13/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]0509178265[/TD]
[TD] 12/16/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]0509178265[/TD]
[TD] 12/16/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]0509861570[/TD]
[TD] 12/23/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]0509861570[/TD]
[TD] 12/23/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]0513386029[/TD]
[TD] 12/2/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]0513386029[/TD]
[TD] 12/2/2018[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about
=IF(COUNTIF($C$2:$C$13,C2)< >COUNTIFS($C$2:$C$13,C2,$D$2:$D$13,D2),"Yes","")

 

[gaz_chops]

Try

=IF(COUNTIFS($C$2:$C$30,C2,$D$2:$D$30,D2)=1,"No Match","")

 

[rogaret]

perfect - thank you!!

 

[Fluff]

You're welcome & thanks for the feedback