Jun 23 2022 06:31 AM
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
Jun 23 2022 07:18 AM
@Gary1964 Perhaps you can use the technique used in the attached file.
Jun 23 2022 07:37 AM
Maybe you find the solution of this discussion helpful.
Jun 29 2022 02:35 AM
@OliverScheurich thank you for sharing the link. I have embedded my FILTER formula in an IFBLANK statement and it did exactly what I needed.
Jun 29 2022 01:20 PM