Running unique count of occurrence on table based on date

[Minx_Minxy]

Hello, I have a report that is extracted daily Mon-Fri. I want to show the unique ticket number (because sometimes is duplicated) that is overdue on the day I extract the report and how many day(s) that ticket has been in the inbox and do that for the subsequent days.

Examples:

1) Overdue ticket #12345 was in the inbox on the 29/01/24 so days in inbox = 1 and then on 30/01/24 the ticket is still in the inbox so days in inbox = 2.
2) The ticket # 54321 was in the inbox on the 10/01/24 and was overdue so days in inbox =1 and then ticket shows up on report again on the 29/01/24, then days in inbox = 2
3) Ticket # 56789 arrived on inbox 18/12/23 overdue and it has been in the inbox up until the 29/01/24

here is what I have so far:

Book2.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Monday	Days In Inbox	What I want	Days Overdue	Tuesday	Days In Inbox	What I want	Days Overdue	Wednesday	Days In Inbox	What I want	Days Overdue	Thursday	Days In Inbox	Days Overdue	Friday	Days In Inbox	Days Overdue				29/01/2024
2	5019370	3	1	-1	5019370	3	2	-2	5019370	3	3	-3	0	1		0	1					30/01/2024
3	5054052	7	5	-46	5054052	7	6	-47	5054052	7	7	-48										31/01/2024
4	5053988	7	5	-54	5053988	7	6	-55	5053988	7	7	-56										01/02/2024
5	5053984	7	5	-58	5053984	7	6	-59	5053984	7	7	-60										02/02/2024
6	5051446	2	2	-130	5051448	2	1	-31	5051448	2	2	-32
7	4964802	7	5	-43	4964802	7	6	-44	4909899	8	8	-72
8	5060984	2	1	-30	4964621	7	6	-71	4964802	7	7	-45
9	5057941	2	1	-89	5060984	2	2	-31	4964621	7	7	-72
10	5004163	9	7	-11	5057941	2	2	-90	5004163	9	9	-13
11	4994843	4	4	-313	5004163	9	8	-12	4917147	29	29	-62
12	4987028	4	4	-57	4917147	29	28	-61	4909904	10	10	-72
13	4917147	29	27	-60	4909904	10	9	-71	4826294	29	29	-402
14	4909904	10	8	-70	4826294	29	28	-401	5053735	2	2	-5
15	4826294	29	27	-400	4980661	26	26	-31	5056377	4	4	-12
16	4980661	26	25	-30	5053735	2	1	-4	5053736	3	3	-5
17	5062768	1	1	-29	5056377	4	3	-11	4978266	29	29	-66
18	5056377	4	2	-10	5053736	3	2	-4	4929416	29	29	-59
19	5053736	3	1	-3	4978266	29	28	-65	0
20	4978266	29	27	-64	4929416	29	28	-58
21	4929416	29	27	-57	0
22	0
23
24
25
26
27
Table

Cell Formulas
Range	Formula
A2:A22	A2	=UNIQUE(FILTER(Data!$B:$B,Data!$A:$A=V1*(Data!$D:$D="X")))
E2:E21	E2	=UNIQUE(FILTER(Data!$B:$B,Data!$A:$A=V2*(Data!$D:$D="X")))
I2:I19	I2	=UNIQUE(FILTER(Data!$B:$B,Data!$A:$A=V3*(Data!$D:$D="X")))
M2	M2	=UNIQUE(FILTER(Data!$B:$B,Data!$A:$A=V4*(Data!$D:$D="X")))
N2,Q2,B2:B21,F2:F20,J2:J18	N2	=SUM(IF(FREQUENCY(IF(Data!$B:$B=M2,Data!$A:$A),Data!$A:$A)>0,1))
O2	O2	=IFERROR(VLOOKUP($V$4&M2,CHOOSE({1,2},Data!$A:$A&Data!$B:$B,Data!$C:$C),2,FALSE),"")
P2	P2	=UNIQUE(FILTER(Data!$B:$B,Data!$A:$A=V5*(Data!$D:$D="X")))
R2	R2	=IFERROR(VLOOKUP($V$5&P2,CHOOSE({1,2},Data!$A:$A&Data!$B:$B,Data!$C:$C),2,FALSE),"")
V1	V1	=TODAY()-WEEKDAY(TODAY(),3)
V2:V5	V2	=V1+1
L2:L18	L2	=IFERROR(VLOOKUP($V$3&I2,CHOOSE({1,2},Data!$A:$A&Data!$B:$B,Data!$C:$C),2,FALSE),"")
H2:H20	H2	=IFERROR(VLOOKUP($V$2&E2,CHOOSE({1,2},Data!$A:$A&Data!$B:$B,Data!$C:$C),2,FALSE),"")
D2:D21	D2	=IFERROR(VLOOKUP($V$1&A2,CHOOSE({1,2},Data!$A:$A&Data!$B:$B,Data!$C:$C),2,FALSE),"")
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
Data!_FilterDatabase	=Data!$A$1:$D$1032	J2:J18, B2:B21, F2:F20, L2:L18, A2, D2:D21, E2, H2:H20, I2, M2:R2

The formula I have in column J works perfectly, but not for the other columns. On columns B,F & J the numbers is always the same. In columns C,G and K, I've added what I want the formula to show.

I just need to keep a Monday to Friday report so weekend dates won't be on the report.


This is a simplified sample of the master data.

Book2.xlsx
	A	B	C	D
1	Extraction Date	Tkt ID	Days to Due	Overdue
2	29-Jan	5019370	-1	X
3	29-Jan	5019370	-1	X
4	29-Jan	5054052	-46	X
5	29-Jan	5053988	-54	X
6	29-Jan	5053984	-58	X
7	29-Jan	4964802	-43	X
8	29-Jan	4964802	-43	X
9	29-Jan	5060984	-30	X
10	29-Jan	5004163	-11	X
11	29-Jan	4994843	-313	X
12	29-Jan	4987028	-57	X
13	29-Jan	4826294	-400	X
14	29-Jan	4980661	-30	X
15	29-Jan	4980661	-30	X
16	29-Jan	5056377	-10	X
17	29-Jan	5053736	-3	X
18	29-Jan	4978266	-64	X
19	29-Jan	4929416	-57	X
20	30-Jan	5019370	-2	X
21	30-Jan	5019370	-2	X
22	30-Jan	5054052	-47	X
23	30-Jan	5053988	-55	X
24	30-Jan	5053984	-59	X
25	30-Jan	5051448	-31	X
26	30-Jan	4964802	-44	X
27	30-Jan	4964802	-44	X
28	30-Jan	4964621	-71	X
29	30-Jan	4964621	-71	X
30	30-Jan	5060984	-31	X
31	30-Jan	5004163	-12	X
32	30-Jan	4917147	-61	X
33	30-Jan	4909904	-71	X
34	30-Jan	4826294	-401	X
35	30-Jan	4980661	-31	X
36	30-Jan	4980661	-31	X
37	30-Jan	5053735	-4	X
38	30-Jan	5056377	-11	X
39	30-Jan	5053736	-4	X
40	30-Jan	4978266	-65	X
41	30-Jan	4929416	-58	X
Sheet5

Any thoughts would be very helpful. Thank you