Forum Discussion

Robert_wood's avatar
Robert_wood
Copper Contributor
Jul 17, 2023
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 ...
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jul 18, 2023

    Robert_wood How about this one then?

    =LET(
        filtered, FILTER(
            PythonData,
            PythonData[#Headers] = $A$1
        ),
        FILTER(filtered, filtered <> "")
    )

Resources