Rodney2485
Jun 11, 2024Brass Contributor
Trouble removing CALC Error
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.