Unique filter returns zero (2 columns)

[PacVII]

I have been looking all over for some help with a formula and not getting anywhere so I will just ask here please. I am sure this is probably simple and I am just not getting it. Story of my life….

I have found where we can filter for one column and remove the zero, but I am filtering on two.

Using Excel 365. I have this working great but it returns a zero for the blank cells. How can I improve on this and remove the zero from the results?

=IFERROR(FILTER(UNIQUE(A4:A250),COUNTIF(F4:F250,UNIQUE(A4:A250))=0),"")

 

[Fluff]

Using Excel 365.

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=LET(u,UNIQUE(FILTER(A4:A250,A4:A250<>"")),FILTER(u,COUNTIF(F4:F250,u)=0,""))