So I already have the following formula:
=UNIQUE(FILTER(AI2:AI1500,(AI2:AI1500<>"")*(ISNUMBER(SEARCH(",",AI2:AI1500)))))
This indexes me a list of unique values from Array AI2:AI1500 where the value is not blank and contains a comma.
I want to further enhance this formula and further limit my resulting list of unique values, by also looking at another adjacent array AM2:AM1500 (which is a list of dates) and only returning a unique value if the value on the same row in Array AM2:AM1500 is within the last 60 days,
Anyone know how to tweak the above formula to include this additonal criteria?
=UNIQUE(FILTER(AI2:AI1500,(AI2:AI1500<>"")*(ISNUMBER(SEARCH(",",AI2:AI1500)))))
This indexes me a list of unique values from Array AI2:AI1500 where the value is not blank and contains a comma.
I want to further enhance this formula and further limit my resulting list of unique values, by also looking at another adjacent array AM2:AM1500 (which is a list of dates) and only returning a unique value if the value on the same row in Array AM2:AM1500 is within the last 60 days,
Anyone know how to tweak the above formula to include this additonal criteria?