How to find duplicates within 5 days of each other in data set

[szita2000]

	A	B	C	D	E
Date	Name	Product	Concan	Count
Daffy Duck	Apple	Daffy DuckApple
Bugs Bunny	Pear
Bugs Bunny	Orange
Bugs Bunny	Orange
Pepe Le Pew	Kiwi
Daffy Duck	Apple

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]01/01/2018[/TD]

[TD="align: right"]0[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]03/01/2018[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]03/01/2018[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]07/01/2018[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]12/01/2018[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]05/01/2018[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D2[/TH]
[TD="align: left"]=B2&C2[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E2[/TH]
[TD="align: left"]=COUNTIFS($D:$D,$D2,$A:$A,$A2>=($A2+5),$A:$A,$A2<=($A2+5))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]




[TABLE="width: 85%"]
<tbody>[TR]
[TD]Hi Guys.

I can't figure this one out.
In the data set above I have to highlight duplicates that are occur within 5 days of each other.
(This is to filter out of someone processed the same purchasing twice by accident)

I tried to concatenate the name and product in to a helper column on D:D - That would make each purchase unique,
I can't work out how to collect and compare the date after the combinations.
I tried to go with count ifs but the criterias of >= than date +5 days doesn't seems to be working.
In the data set above Line 2,7 and 4,5 should be highlighted/put in to a separate list somehow

Any ideas most welcome[/TD]
[/TR]
</tbody>[/TABLE]

 

[VBA Geek]

You are almost there I think:

Excel 2010
	A	B	C	D
1	Date	Name	Product	dupe?
2	1/1/2018	Daffy Duck	Apple	TRUE
3	1/3/2018	Bugs Bunny	Pear	FALSE
4	1/3/2018	Bugs Bunny	Orange	TRUE
5	1/8/2018	Bugs Bunny	Orange	TRUE
6	1/12/2018	Pepe Le Pew	Kiwi	FALSE
7	1/5/2018	Daffy Duck	Apple	TRUE
Sheet2

Cell Formulas
Range	Formula
D2	=COUNTIFS($B$2:$B$7,B2,$C$2:$C$7,C2,$A$2:$A$7,"<"&A2+6,$A$2:$A$7,">"&A2-6)>1
D3	=COUNTIFS($B$2:$B$7,B3,$C$2:$C$7,C3,$A$2:$A$7,"<"&A3+6,$A$2:$A$7,">"&A3-6)>1
D4	=COUNTIFS($B$2:$B$7,B4,$C$2:$C$7,C4,$A$2:$A$7,"<"&A4+6,$A$2:$A$7,">"&A4-6)>1
D5	=COUNTIFS($B$2:$B$7,B5,$C$2:$C$7,C5,$A$2:$A$7,"<"&A5+6,$A$2:$A$7,">"&A5-6)>1
D6	=COUNTIFS($B$2:$B$7,B6,$C$2:$C$7,C6,$A$2:$A$7,"<"&A6+6,$A$2:$A$7,">"&A6-6)>1
D7	=COUNTIFS($B$2:$B$7,B7,$C$2:$C$7,C7,$A$2:$A$7,"<"&A7+6,$A$2:$A$7,">"&A7-6)>1

 

[szita2000]

Thanks a mill VBA Geek!