filtering out zero values from results

[Skrej]

I have the following formula which searches for all values of 'a' across several sheets.

=LET(d,VSTACK(aug:sep!$c$8:$$37),n,INDEX(d,,1),u,UNIQUE(FILTER(n,n<>"")),HSTACK(u,BYROW(u,LAMBDA(br,SUMPRODUCT((INDEX(d,,1)=br)*(d="A"))))))

This works as intended, except it includes zero values as you can see( Under 'Absences) column. I'd like to exclude values(or not show) names where the value is zero.

I'm not sure how to filter out the entries with zero instances. I'd appreciate if someone could show me how to do that. I tried the following, but get a message about not being able to include a paramater to a LET function after defining its calculation.

=LET(d,VSTACK(Aug!C8:V37),n,INDEX(d,,1),u,UNIQUE(FILTER(n,n<>"")),HSTACK(u,BYROW(u,LAMBDA(br,SUMPRODUCT((INDEX(d,,1)=br)*(d="A"))))),FILTER(a,CHOOSECOLS(a,2)<>0))

 

[hagia_sofia]

Hello again, adjust the fomula like this: a,HSTACK... and it should work.

 

[Skrej]

Many thanks, again. That fixed it.