Forum Discussion
Gary1964
Jun 23, 2022Copper Contributor
UNIQUE and FILTER dynamic array formulae
When using the UNIQUE or FILTER dynamic array formulae, if my source data contains blank cells they appear as 0 in the results. Is it possible to return them as blanks
Riny_van_Eekelen
Jun 23, 2022Platinum Contributor
Gary1964 Perhaps you can use the technique used in the attached file.