Flag Yes If CustomerID occurs again within 3 days

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.

Sample file attached.
SCIPSample.xlsx

Shouldn't Row 18 be Yes? Or is 1/14 considered more than 4 days from 1/10?

Try this

=IF(SUMPRODUCT(--([Date]>=[@Date]),--( [Date]<= [@Date]+3),-- ([Activity ID]>[@[Activity ID]]), --([Customer ID]=[@[Customer ID]])), "Yes", "No")

Its within 3 days that I need flagged as Yes

This appears to work, It does on the sample data, I am testing it on the full data now, will take a few.... Thanks sooo much. I will update when I know for certain.

Did you try that formula?