UNIQUE and FILTER dynamic array formulae

Copper Contributor

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 

4 Replies

@Gary1964 Perhaps you can use the technique used in the attached file.

 

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

@Gary1964 

As variant of that

=LET( f, FILTER(range,condition), IF( f="", "", f) )