Dates already in Range

[sur]

Hello All,

Need to find the repeated date range in the columns if equal to article numbers.

Article No.	Start Date	End Date	Result
1	10/12/2018	11/12/2018	Repeated
2	10/20/2018	11/18/2018	Unique
3	10/18/2018	11/19/2018	Unique
4	10/25/2018	11/28/2018	Unique
1	10/13/2018	11/11/2018	Repeated

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

 

[ravishankar]

In your example, article number is repeated but not the dates. if so Column D

= if(countif($A$1:$A$100, $A1)>1,"repeated","Unique")

drag it down to the last row and replace 100 with last row number.
ravi shankar