Find Duplicate only if date is within X days of original

[arcaidius]

B	F	J
ID#	Date	Duplicate?

<tbody>
</tbody>

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.