Find Duplicate only if date is within X days of original

[arcaidius]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]B
[/TD]
[TD]F
[/TD]
[TD]J
[/TD]
[/TR]
[TR]
[TD]ID#
[/TD]
[TD]Date
[/TD]
[TD]Duplicate?
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Iwas wondering if you could Help me out with a formula? I need Column “J” tosearch for duplicate values in column “B” and say “Yes” only if the date incolumn “F” is within 180 days (6 months) of the original value.

 

[Eric W]

Try:

Book1
	B	F	J
1	ID#	Date	Duplicate?
2	1	1/1/2019	Yes
3	2	2/1/2019
4	3	3/1/2019
5	1	1/2/2019	Yes
6	2	2/1/2018
7	3	11/1/2019
Sheet6

Cell Formulas
Range	Formula
J2	=IF(COUNTIFS(B:B,B2,F:F,">="&F2-180,F:F,"<="&F2+180)>1,"Yes","")

 

[arcaidius]

Thanks Eric W. This worked, I swear I had it at the tip of my fingers.


=IF(COUNTIFS(B:B,B2,F:F,">="&F2-180,F:F,"<="&F2+180)>1,"Yes","")

 

[Eric W]

Happy to help.