Forum Discussion

sgeisel1975430's avatar
sgeisel1975430
Copper Contributor
Sep 08, 2024
Solved

Filter data - then filter the filtered data

I have some data that is over 3200 lines with multiple columns each   I know I can just select the headers and put a filter in each column - and can drill down the data    But - I want to create ...
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Sep 09, 2024

    Hi sgeisel1975430 

     

    See attached sample file where a tab named List is hidden. Lists on that sheet are dynamically adjusted according the filter(s)/criteria already applied on the Query tab:

     

    With Data formatted as a structured Table, FILTER formula on the Query tab is:

    =LET(
  Filtered, FILTER(Data,
              IF(ISBLANK(B4), 1, Data[Application] = B4) *
              IF(ISBLANK(C4), 1, Data[Type] = C4) *
              IF(ISBLANK(D4), 1, Data[Series] = D4) *
              IF(ISBLANK(E4), 1, Data[Size] = E4) *
              IF(ISBLANK(F4), 1, Data[Geometry] = F4)
  ),
  IF(QueryCriterias, Filtered, "Select at least a criterion")
)

     

    Where QueryCriterias in defined in Name Manager as: =COUNTA(Query!$B$4:$F$4)

Harun24HR's avatar
Harun24HR
Bronze Contributor
Sep 09, 2024
You can use IFS() function to execute filter function based on multiple criteria. Can you please share a sample file so that we can check more. Also can you please show us few scenario that you want.

Resources