We use a rather long formula something like:
=ArrayFormula(JOIN(", ",UNIQUE(FILTER(SOURCERANGE!A1:A99999,SOURCERANGE!N1:N99999=A2 ))))
Some cells in our table gave results and they print nicely.
But some cells do NOT have results. And they print as
I have never quite liked the
#N/A and would rather show an empty cell or a dash.
The only solution so far that I have found is to add an
ISNA() formula around it, but then this feels silly because the initial formula is executed twice.
Question: is there an easy way to tell sheets to print
"" instead of