Count of consecutive months same data value appears

[rhonllanders]

=LET(s,SEQUENCE(999),XLOOKUP(0,IFNA(MATCH(EDATE(A2,-s),FILTER(A$2:A2,(B$2:B2=B2)*(C$2:C2=C2)*(D$2:D2=D2)),0),0),s))

Hi! I need a little guidance on the above formula that I have been using since Jun 2023 and it worked perfectly, but once I added data for Jun 2024 it doesn’t seem to count consecutive months anymore. The formula was built to look for the same Task Key, Exception and Issue Key combo (helper) and count their recurrence in consecutive months only. Example: If issue appeared in Jun-2023 and July-2023 but was resolved in Aug-2023 and then the same issue (helper) reappeared in Sep-2023, the count of consecutive months would start over beginning with Sep-2023. Ideally, I'd like to use just the helper as the unique identifier.

For some reason, it is not working now that my data contains Jun 2023 and Jun 2024.

Please let me know if more detail is needed. And thanks in advance for any guidance.

A	B	C	D	E	F
Month	Task Key	Exception	Issue Key	helper	# Consecutive Months Unresolved
6/1/2023	ABC-1234567890	Overdue Issue	I543210	ABC-1234567890Overdue InvoiceI543210	1
7/1/2023	ABC-1234567890	Overdue Issue	I543210	ABC-1234567890Overdue InvoiceI543210	2
9/1/2023	ABC-1234567890	Overdue Issue	I543210	ABC-1234567890Overdue InvoiceI543210	1
10/1/2023	ABC-1234567890	Overdue Issue	I543210	ABC-1234567890Overdue InvoiceI543210	2
11/1/2023	ABC-1234567890	Overdue Issue	I543210	ABC-1234567890Overdue InvoiceI543210	3

 

[rhonllanders]

Please disregard! This was user error... I had some values stored as numbers and some as text and the formula read them as different values. Sorry! and Thanks!