Filter Formula - Change "0" to "Blank" cells

[jayjay123]

Hi guys! In search for an expert to help me with the Filter formula.

As part of the filter formula, if there is a blank cell, it's popping up with the number "0". Is there any way to change it to "Blank"?

I've tried:
=FILTER(A:A,IFERROR(B:B=B1,"")

Thanks for your help!!

 

[Peter_SSs]

That is not a valid formula. Did you mean this =FILTER(A:A,IFERROR(B:B=B1,""))

Depends a bit on what sort of values you have in column A. Could we have a small set of dummy data and the expected results?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[jorismoerings]

Hi,

From your formula I assume there's an empty field in column while the criteria on the same line is true.
If that's a correct assumption, try this:

=SUBSTITUTE(FILTER(A:A,B:B=B1,""),"0","")

But be aware, this will remove all 0 even in other entries, ic 4405 becomes 445.
To have a better look at the solution follow @Peter_SSs suggestion and show some sample data

 

[jorismoerings]

As addition to my previous post, something like this is a better option:

=FILTER(IF(ISBLANK(A:A),"",A:A),B:B=B1,"")