Forum Discussion
Filter selection of top text
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" ?
Thank you for your patience SergeiBaklan It will only be one feb. 1, one feb. 2 Every date occur once.
If I select to show columns from D to F (Ansatt 1 to Ansatt 3) Index 2, index 4. and include "Hallo" The result should be:
01.feb Ansatt 1 - Ansatt 2
02.feb
03.feb Ansatt 2
04.feb
05.feb
06.feb Ansatt 2 - Ansatt 3Best Regards
- Geir
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