Forum Discussion
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)) ...
None of the entries in column G match the condition.
This formula gives the same result:
=LET( filtered, FILTER( F2:F9000,(G2:G9000=H2)+(G2:G9000=H3)>0), UNIQUE(filtered))
And if you convert your data to a table there is no need to refer to this many rows.
This formula gives the same result:
=LET( filtered, FILTER( F2:F9000,(G2:G9000=H2)+(G2:G9000=H3)>0), UNIQUE(filtered))
And if you convert your data to a table there is no need to refer to this many rows.