Dates already in Range

[sur]

Hello All,

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

[TABLE="width: 298"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]Article No.[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10/12/2018[/TD]
[TD]11/12/2018[/TD]
[TD]Repeated[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10/20/2018[/TD]
[TD]11/18/2018[/TD]
[TD]Unique[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10/18/2018[/TD]
[TD]11/19/2018[/TD]
[TD]Unique[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10/25/2018[/TD]
[TD]11/28/2018[/TD]
[TD]Unique[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10/13/2018[/TD]
[TD]11/11/2018[/TD]
[TD]Repeated[/TD]
[/TR]
</tbody>[/TABLE]

 

[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