Forum Discussion
Solved
Formula to construct filtered dynamic arrays
I would like to have an efficient way to construct a dynamic array from existing data. Assume Sheet1 with data having column headers and Sheet2 used to focus on a column of data in Sheet1. Currently ...
Robert_wood How about this one then?
=LET( filtered, FILTER( PythonData, PythonData[#Headers] = $A$1 ), FILTER(filtered, filtered <> "") )
flexyourdata, I like your suggestion. Very powerful. However, it causes blank cells in the table to be replicated as cells with a value of 0 in the result. This makes functions like AVERAGE to fail.
Robert_wood How about this one then?
=LET(
filtered, FILTER(
PythonData,
PythonData[#Headers] = $A$1
),
FILTER(filtered, filtered <> "")
)