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...

Rep	Customer	Order Num	Due Date	No Match
		0507075687	12/12/2018
		0507075687	12/12/2018
		0508231008	12/7/2018
		0508231008	12/13/2018
		0508780590	12/13/2018
		0508780590	12/13/2018
		0509178265	12/16/2018
		0509178265	12/16/2018
		0509861570	12/23/2018
		0509861570	12/23/2018
		0513386029	12/2/2018
		0513386029	12/2/2018

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[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