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),"")
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),"")