Formula to check if 3 cells have identical value

[Captain Smith]

Data is in cells A1 to A5. What formula can I enter in B1 that will return "YES" if any three of these cells have identical data? If 2,4 or 5 of these cells have identical data return nothing. If none of the cells have identical data, return nothing.

Thank you.

 

[Scott Huish]

If I'm understanding this correctly, give this a try:

=IF(SUMPRODUCT(--(C1:C1000=A1),--(D1:D1000=B1)),"YES MATCH!", "NO MATCH")