This is the Formula i’m using, however when the formula doesnt return a result I get the #Calc error.

=LET( filtered, FILTER( F2:F9000, ISNUMBER(XMATCH(G2:G9000, H2:H3, )) ), UNIQUE(filtered))

I’ve tried inserting “No Event” into the formula but either I’m not putting it into the string correctly or I need to do something else.

​This is the Formula i’m using, however when the formula doesnt return a result I get the #Calc error. =LET( filtered, FILTER( F2:F9000, ISNUMBER(XMATCH(G2:G9000, H2:H3, )) ), UNIQUE(filtered)) I’ve tried inserting “No Event” into the formula but either I’m not putting it into the string correctly or I need to do something else.  Read More

​