Forum Discussion
An alternative to the function FILTER
Hello, I have difficulties with getting information from one array in one sheet to another array in another sheet, for the following reason : I have one data in common between the two arrays, an...
You may use FILTER with your workbook, but the results of the formula cannot be returned within a table. A table fills formulas automatically, but is scalar-based (1 cell, 1 formula = 1 result). If you convert the table to a range in the second sheet, FILTER will work.
I'll refer you to OliverScheurich 's solution.