Countifs Results Problem

[rex759]

Hello,
I want to show the message “>3” for all dates involved if the date inputted falls between a 30 day period.

In the example below, I want the dates 2/1/16 & 2/22/16 to also show the message “>3” because they are part of the 4 dates that is causing the error.

Is there a better formula to show all dates involved than countifs to obtain these results?

Excel Workbook
	A	B	C
1	Date	Mode	Error
2	2/1/16	1
3	2/10/16	1	>3
4	3/10/16	1
5	4/10/16	1
6	5/10/16	1
7	6/10/16	1
8	7/10/16	1
9	1/11/16	1
10	2/9/16	1	>3
11	2/22/16	1
Sheet1

Excel 2010

Cell Formulas
Range	Formula
C2	=IF(COUNTIFS($A$2:$A$11,">"&A2-15,$A$2:$A$11,"<"&A2+15,$B$2:$B$11,"="&B2)>3,">3","")
C3	=IF(COUNTIFS($A$2:$A$11,">"&A3-15,$A$2:$A$11,"<"&A3+15,$B$2:$B$11,"="&B3)>3,">3","")
C4	=IF(COUNTIFS($A$2:$A$11,">"&A4-15,$A$2:$A$11,"<"&A4+15,$B$2:$B$11,"="&B4)>3,">3","")
C5	=IF(COUNTIFS($A$2:$A$11,">"&A5-15,$A$2:$A$11,"<"&A5+15,$B$2:$B$11,"="&B5)>3,">3","")
C6	=IF(COUNTIFS($A$2:$A$11,">"&A6-15,$A$2:$A$11,"<"&A6+15,$B$2:$B$11,"="&B6)>3,">3","")
C7	=IF(COUNTIFS($A$2:$A$11,">"&A7-15,$A$2:$A$11,"<"&A7+15,$B$2:$B$11,"="&B7)>3,">3","")
C8	=IF(COUNTIFS($A$2:$A$11,">"&A8-15,$A$2:$A$11,"<"&A8+15,$B$2:$B$11,"="&B8)>3,">3","")
C9	=IF(COUNTIFS($A$2:$A$11,">"&A9-15,$A$2:$A$11,"<"&A9+15,$B$2:$B$11,"="&B9)>3,">3","")
C10	=IF(COUNTIFS($A$2:$A$11,">"&A10-15,$A$2:$A$11,"<"&A10+15,$B$2:$B$11,"="&B10)>3,">3","")
C11	=IF(COUNTIFS($A$2:$A$11,">"&A11-15,$A$2:$A$11,"<"&A11+15,$B$2:$B$11,"="&B11)>3,">3","")

 

[rex759]

Spoke too soon. Still not working. Going to give it rest for the night.

 

[admiral100]

In F2 try this and copy down & side (Array Formulas)

=IF($D2>3,IFERROR(INDEX($E$2:$E$11,SMALL(IF($D$2:$D$11>=3,ROW($D$2:$D$11)-1,""),COLUMN(A$1)),1),""),"")

Date	Mode	Error	#	Sites	Sites	Sites	Sites		Range	Date Range (+15)
02/01/2016	1		3	1111					1/17/16	2/16/16
02/10/2016	1	>3	4	1112	1111	1112	1119	1120	1/26/16	2/25/16
03/10/2016	1		1	1113					2/24/16	3/25/16
04/10/2016	1		1	1114					3/26/16	4/25/16
05/10/2016	1		1	1115					4/25/16	5/25/16
06/10/2016	1		1	1116					5/26/16	6/25/16
07/10/2016	1		1	1117					6/25/16	7/25/16
01/11/2016	1		1	1118					12/27/15	1/26/16
02/09/2016	1	>3	4	1119	1111	1112	1119	1120	1/25/16	2/24/16
2/22/16	1		3	1120					02/07/2016	03/08/2016

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