SOLVED

Excel filter function - dynamic include column

Steel Contributor

Hi,

 

Is it possible to have an dynamic include column, using a formule with the filter function?

 

=FILTER(Tabell242[Navn];Tabell242[D6]<>"";"No one")

 

Where Tabell242[D6] is build "D"&Cellvalue

Like in this picture, I would like to use the Value in H4 (6) to select my column for filter.

 

filter dynamic include.PNG

 

Best Regards

- Geir

 

 

 

7 Replies
best response confirmed by Geir Hogstad (Steel Contributor)
Solution

@Geir Hogstad 

Geir, I didn't tested, but something like

=FILTER(Tabell242[Navn];
   INDEX(Tabell242;;XMATCH("D" & H$4,Tabell242[#Headers],0))<>"";
   "No one")

shall work

Thank you @Sergei Baklan it worked perfect.

 

Have a nice weekend.

 

BR

/Geir

@Geir Hogstad , you are welcome and have a nice weekend too

@Sergei Baklan 

 

Hello.

 

I need the opinion of an excel specialist in using the filter function.

 

I want from the search in 5 columns with numbers, on which dates or columns a specific number is included.

 

I’m' using the filter function but it does not give me results that I want, it gives me an error.

 

Can you tell me what I’m doing wrong?

 

Thank you in advance

 

I have attached the excel file

@katialou 

First, use frittered range and the filter of the same size (first starts from A1, another from B2).

Second, as a filter it shall be used not a matrix but single column array with equivalents of TRUE and FALSE. 

As variant that could be

=FILTER(A2:G30,MMULT(--(B2:G30=12),SEQUENCE(6,1,1,0)))

For the future, please ask new question with new conversation from here https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral, that's not a good practice to mix different question in one thread.

 

Hello

Thank you very much for your help and your answer to my post!

Sorry I was late to thank you and reply to your post. I wrote from here because my post request was not accepted on the main page of the forum.

I am grateful for your help.

If you want you can visit my website to listen to beautiful music.

https://www.friendsofmusic.gr/

In the coming days I am thinking of sending you a gift card in your email.

Katia

 

@Sergei Baklan 

@katialou 

Hi Katia - appreciate, thank you, that's very nice!

1 best response

Accepted Solutions
best response confirmed by Geir Hogstad (Steel Contributor)
Solution

@Geir Hogstad 

Geir, I didn't tested, but something like

=FILTER(Tabell242[Navn];
   INDEX(Tabell242;;XMATCH("D" & H$4,Tabell242[#Headers],0))<>"";
   "No one")

shall work

View solution in original post