UNIQUE and FILTER dynamic array formulae

Question

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&nbsp;

riny_van_eekelen · Answer

Gary1964&nbsp;Perhaps you can use the technique used in the attached file.&nbsp;

oliverscheurich · Answer

Gary1964&nbsp;Filter function returning a "0" (Zero) when the source cell is blank or null - Microsoft Tech CommunityMaybe you find the solution of this discussion helpful.

gary1964 · Answer

OliverScheurich&nbsp;thank you for sharing the link.&nbsp; I have embedded my FILTER formula in an IFBLANK statement and it did exactly what I needed.&nbsp;

sergeibaklan · Answer

Gary1964&nbsp;
As variant of that
=LET( f, FILTER(range,condition), IF( f="", "", f) )

Forum Discussion

UNIQUE and FILTER dynamic array formulae

Share

Resources