Flag several duplicate columns that occur within a 3 day range.

[Wrush4]

Hi,
I have the following named Ranges
Activity ID Numeric, Unique --Key Field
Customer Name Name
Customer ID Numeric,
Ticket ID Numeric
ClosedDate1 Date
AgentID1 FLast
SCIP Event Yes / No

What I am attempting to do, is Flag SCIP Event With a "Yes" for each activity ID where the Customer ID has a duplicate with a higher Activity ID and occurs within 3 days.
I currently have the following, which works, but requires an advanced sort of Customer ID and Ticket ID on the raw data page (20k rows currently) to work properly, this has to be redone every time the raw data is updated (daily)

=IFERROR(IF(AND(COUNTIFS(CustomerID,[@[Customer ID]])>1,OFFSET([@ClosedDate1],1,0,1,1)-[@ClosedDate1]<4,OFFSET([@[Customer ID]],1,0,1,1)=CustomerID),"Yes","No"),"No")

I initially tried using an If(And(Index(Match)))), which obviously failed due to match only going to the first record. I would prefer to do this without VBA, but any working solutions would be appreciated.

 

[Wrush4]

Activity ID Customer ID ClosedDate1 SCIP Event
175380113 66390 1/18/2016 No
175108970 67325 1/3/2016 No
175377969 67527 1/18/2016 No
175329009 69907 1/15/2016 No
175254667 70434 1/11/2016 Yes
175288212 70434 1/13/2016 Yes
175289338 70434 1/13/2016 No
175350127 71084 1/16/2016 No
175436058 71084 1/21/2016 No
175419568 72426 1/20/2016 No
175477439 73218 1/23/2016 No
175269048 73505 1/12/2016 No
175500262 74267 1/24/2016 No
175220443 74441 1/9/2016 No
175398826 74561 1/19/2016 No
175477283 75164 1/23/2016 No
175235463 75843 1/10/2016 No
175311663 75843 1/14/2016 No
175479183 75843 1/23/2016 No

 

[Wrush4]

Can anyone help? Am I being unclear somehow? I know this can be done.

 

[Wrush4]

I got the solution here.
Flag Yes If CustomerID occurs again within 3 days [SOLVED]