Filtered Cells Show 0 Instead Of Being Blank

[Skip_General]

How can I get formula filtered data to just show blank cells as blank instead of it placing a 0 (or 1/0/1900 if it's a date formatted cell) in it?

Table Data:
Table.PNG

Filtered Data:
Filtered.PNG

[ChemistB]

Format the cells as Custom 0;-0;;@
For dates
"m/dd/yyyy";-0;;@

[Skip_General]

Thanks for the reply, ChemistB.

Not the route I had expected to take but I can make that work. Was hoping to actually make the result null, so when I utilize the data elsewhere; it will always be null.

I can do it this way, I just now have to format every cell with the custom you gave me each place I utilize any of this filter data.

Again. Thanks for the help. This definitely gets me moving on to other challenges.

Skip

[phatdear]

If you don't mind converting the results to TEXT, then you could simply add &"" after the formula, for instance,

Assume your data is in range A3:C6

=FILTER(A3:C6,A3:A6="a")&""

Or if you want to keep them as they are, then you could use the below approach

=IFNA(FILTER(IF(A3:C6="",NA(),A3:C6),A3:A6="a"),"")