Hello all, trying to use the new UNIQUE and FILTER function's.

=UNIQUE(array,[by_col],[exactly_once])

=FILTER(array,include,[if_empty]

with the include function comparing a partial STRING to another partial STRING. I will be making 2 versions of this hopefully, one if STRINGS match, one if they do not.

-The STRING is actually just a date, unfortunately on the array side, it is a date and time stamp that cell formatting cannot seem to grapple.


Here are the important values:

Date to compare against - CurrentMonth!AG2 i.e. 9/15/2022

Array of dates within data - OldBackLog!I2:OldBackLog!I5000 i.e. 9/15/2022 4:22 PM

Array of data to be filtered with only unique results- OldBackLog!A2:OldBackLog!J5000


Here is the formula I have that I believe is correct:

=UNIQUE(FILTER(OldBackLog!A2:OldBackLog!J5000, <INSERT COMPARISON HERE> ,""),FALSE,TRUE)


And here are the 3 different attempts at a comparison I have tried so far:

XMATCH(CurrentMonth!AG2?,OldBackLog!I2:OldBackLog!I5000,2,1)

ISNUMBER(SEARCH(CurrentMonth!AG2,(OldBackLog!I2:OldBackLog!I5000)))

LEFT(OldBackLog!I2:OldBackLog!I5000,5)=LEFT(CurrentMonth!AG2,5)

Any help/advice will be greatly appreciated!