★ Want to automate Excel? Check out our training academy ★
[ Ссылка ]

★ Get the example file ★
[ Ссылка ]

★ About this video ★
In a recent project, I used FILTER and TEXTJOIN to create a comma-separated list to display in a cell. Unfortunately, when I tried to spill the values for different filter criteria, it created an error.

So, in this view, work through a solution, showing how to spill multiple FILTER functions in Excel.

0:00 Introduction
0:27 Example
2:00 Single FILTER function... the problem!
3:26 Dynamic array inside a Table
4:24 BYROW & LAMBDA Combination
5:47 Alternative solution & concolusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
[ Ссылка ]

★ Where to find Excel Off The Grid ★
Blog: [ Ссылка ]
Twitter: [ Ссылка ]

#MsExcel

свернуть