Forum Discussion

Iron Contributor

Feb 27, 2021

Filter selection of top text

Hi. The goal her is to filter the top texts from a table, when two criteria is met. I manage to get it when I us the whole top text range, but if i onlye select some of the top texts =FILTER(...

filter selction top texts.xlsx11 KB

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Feb 27, 2021

Hogstad_Raadgivning

If for one day only and pre-defined column names, formula could be

=LET(
   selectedHeaders, $F$13#,
   selectedDate,    K2,
   headers,         Tabell1[[#Headers],[Ansatt 1]:[Ansatt 5]],
   data,            Tabell1[[Ansatt 1]:[Ansatt 5]],
   condition,       COUNTIF(selectedHeaders,headers)  *
                   (XLOOKUP(selectedDate,Tabell1[Dato],data)="Hallo" ),
   IFERROR(FILTER(headers, condition),"")
)

which returns