Forum Discussion
Solved
How to ignore #CALC errors without using IFERROR
Hello The subject line basically says it all. I have a dataset in which I'm trying to ignore a series #CALC errors. I usually just use IFERROR(****,""), but for the data I have the returned resul...
reevesgetsaround Not sure I follow but it seems you are using FILTER but don't want to see #CALC! without using IFERROR.
Try this:
=FILTER(C:C,(A:A=E2)*(B:B>4),"")
and copy down.
It works as intended with your formula without IFERROR. My assumption was that you want to return the results in one cell that's why i'd added the TEXTJOIN.
Thank you Riny and Thank you Quad for your perseverance - I have got it working now without the IFERROR.
Best Regards
Best Regards