Forum Discussion
Excel filter function - dynamic include column
Geir, I didn't tested, but something like
=FILTER(Tabell242[Navn]; INDEX(Tabell242;;XMATCH("D" & H$4,Tabell242[#Headers],0))<>""; "No one")shall work
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
Hi Katia - appreciate, thank you, that's very nice!