Jun 11 2024 06:01 AM
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.
Jun 11 2024 07:21 AM
Jun 11 2024 07:40 AM
@Rodney2485 Here's a few options for handling the #CALC error in this scenario:
=LET(
filtered, FILTER(F2:F9000, ISNUMBER(XMATCH(G2:G9000, H2:H3))),
IF(ISNUMBER(ROWS(filtered)), UNIQUE(filtered), "No Records")
)
=LET(
incl, ISNUMBER(XMATCH(G2:G9000, H2:H3)),
IF(OR(incl), UNIQUE(FILTER(F2:F9000, incl)), "No Records")
)
=IFERROR(UNIQUE(FILTER(F2:F9000, ISNUMBER(XMATCH(G2:G9000, H2:H3)))), "No Records")
See attached, if needed...