Forum Discussion
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(Tabell1[#Topptekster];FILTER(Tabell1;Tabell1[Dato]=K2)="hallo";"") - OK
=FILTER(Tabell1[[#Topptekster];[Ansatt 1]:[Ansatt 3]];FILTER(Tabell1;Tabell1[Dato]=K2)="hallo";"") - #VALUE
=FILTER(INDEKS(Tabell1[#Topptekster];;2):INDEKS(Tabell1[#Topptekster];;4);FILTER(Tabell1;Tabell1[Dato]=K2)="hallo";"") #Value
Best regards
- Geir
9 Replies
Not sure what is required, making the guess that could be
=FILTER( INDEX(Tabell1[#All], SEQUENCE(ROWS(Tabell1[#All])), XMATCH(F13#,Tabell1[#Headers])), COUNTIF(K2,Tabell1[[#All],[Dato]]) )Thank you SergeiBaklan Not excatly what I am trying to get.
I Would like to the 3 first (or what I decide using INDEX for the heade row.
Ansatt 1 - Ansatt 2 - Ansatt 3
If the date match, and the value in the Ansatt column match Hallo.
This result INDEX(Tabell1[#Topptekster];;2):INDEX(Tabell1[#Topptekster];;4) if the date match, and if it contains "Hallo""
I hope that explain it better.
Best Regards
- Geir
Thank you, but still not clear, sorry. You have predefined table headers, like
Ansatt 1 Ansatt 2 Ansatt 3 and from the you would like to select headers name for which in row with given date we have text "Hallo", i.e. returned result shall be
Ansatt 1 Ansatt 2 , correct ?
But if we have few rows with specified date (01-Feb), shall we take into account columns where at least one "Hallo" for this date, or all rows shall be with "Hallo" ?
Hogstad_Raadgivning , what do you mean under top texts, table headers?
If so, you manually take some header names; define date for the row and would like to return from the table above columns filtered by date; or that's something different?
