Automatically Change 0 to N/A without using a formula

[wlbamc]

I have a spreadsheet which is populated from microsoft forms and if the question isn't answered it returns a 0. I want to change that 0 to N/A without using a formula as there is a whole page filter formula on the worksheet. Can I use a VBA?

 

[Fluff]

Why not just change it in the filter formula?

 

[Fluff]

If you post your formula I can show you how to do it.

 

[wlbamc]

If you post your formula I can show you how to do it.

So this is looking up columns A:P and S on Form 1 and filtering to Abermad tab

=Filter(Form1!A:P,Form1!S:S="Abermad")

Hope this makes sense

Thank you

 

[Fluff]

Ok, how about

=LET(F,FILTER(Form1!A:P,Form1!S:S="Abermad"),IF(F=0,"N/A",F))

 

[wlbamc]

Many thanks works perfectly, much appreciated

 

[Fluff]

You're welcome & thanks for the feedback.