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!
Bookmarks