How to Spill multiple FILTER functions in Excel | Excel Off The Grid 

Excellent. This level of detail in the explanations is what differentiates a good channel from a masterful channel. Superb explanation Mark. Thank you so much.

Awesome use of BYROW!

Didn’t know that would work so “straight forward” within a table.. good to know 👍

Good one! MAP would probably also work instead of BYROW in this example.

Thanks for this, Mark. How would you go about spilling the results per row across columns (i.e. every result per row is put in another column) instead of conatenating them to create only a single result cell per row?

Thank you, I may, with your permission, try a function drop and vstack

is that doable in google sheets?

Very nice.

Great video, I added the unique function inside the formula because locations was appearing multiple times. =BYROW(A1#,LAMBDA(r,TEXTJOIN(", ",TRUE,UNIQUE(FILTER(INV_ON_HAND[BIN_LOCATION_CODE],INV_ON_HAND[ITEM_CODE]=r,""))))) 11HYBB2-TL 207 S010A, S010B, S010C, S011B, S012B, S013A, S013B, S013C, S014C, S018B, S019B, S019C, S023A, S024A, S025B ? How would you add the qty for each location , the total for 11HYBB2-TL = 207

WOW Mark. 👏👏

Drop, Reduce, Vstack & Lambda combination - can't find link in blog, got link? Thanks