How to find duplicate cells for a particular range

[Adnan Halai]

Hi Team,

Greetings!!

I am working on database wherein I am trying to find duplicate based on Sprint. After every few rows, Sprint change, I am unable to change duplicate formula based on a formula.

Data highlighted in Green& Yellow is the result I am looking after in attached data.


Thanks & Regards
Adnan Halai

 

[Haz]

Type the formula in D2, then copy and paste:
=IF(COUNTIFS(A:A,A2,B:B,B2,C:C,C2)>1,"Sprint "&B2&" has duplicate Value","")