Space in my UNIQUE/VSTACK/SORT/FILTER formula??

[thewiseguy]

hello everyone. I am having a hard time diagnosing why there is a blank row in my output. see cell B16 in the attached. Here is my formula:

=LET(u,UNIQUE(VSTACK(SORT(FILTER(Input!$Q$4:$Q$503,ISNA(XMATCH(Input!$Q$4:$Q$503,{"EMA Remove","EMA Locked","EMA No Measure"})))),SORT(Input!$V$4:$V$503),SORT(Input!$X$4:$X$503),SORT(Input!$Z$4:$Z$503),SORT(Input!$AB$4:$AB$503),SORT(Input!$AD$4:$AD$503),SORT(Input!$AF$4:$AF$503),SORT(Input!$AH$4:$AH$503),SORT(Recycle_Calc!B43:B46),SORT(Input!$AK$4:$AK$503))),FILTER(u,u<>""))

Any help would be greatly appreciated!

 

[RoryA]

Most likely that cell contains something like a space.

 

[thewiseguy]

Most likely that cell contains something like a space.

I have found this formula is returning a 0 as the first line:

=SORT(UNIQUE(FILTER('Helper 2'!F3:F502,('Helper 2'!F3:F502<>"")*('Helper 2'!G3:G502<>0))))

any idea why?? (see attached)

 

[RoryA]

Presumably you have a 0 in column F somewhere.

 

[thewiseguy]

Presumably you have a 0 in column F somewhere.

yes i do. here is the formula is column F.

=IFERROR(XLOOKUP(B54,Tbl_Existing[Description],Tbl_Existing[RecycleBoxType]),"")

it is actually a blank, so how do i keep the formula but not have the 0 show as a result?

 

[RoryA]

No, there must be a cell returning 0. You filter out ""

 

[thewiseguy]

No, there must be a cell returning 0. You filter out ""

got it, thank you