Feb 15 2020 07:47 AM
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.
Best Regards
- Geir
Feb 15 2020 08:00 AM
SolutionGeir, I didn't tested, but something like
=FILTER(Tabell242[Navn];
INDEX(Tabell242;;XMATCH("D" & H$4,Tabell242[#Headers],0))<>"";
"No one")
shall work
Feb 15 2020 09:06 AM
Feb 15 2020 09:22 AM
@Geir Hogstad , you are welcome and have a nice weekend too
Aug 09 2020 07:05 AM
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
Aug 09 2020 12:41 PM
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.
Aug 10 2020 03:22 PM - edited Aug 10 2020 04:05 PM
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
Aug 11 2020 08:57 AM
Hi Katia - appreciate, thank you, that's very nice!
Feb 15 2020 08:00 AM
SolutionGeir, I didn't tested, but something like
=FILTER(Tabell242[Navn];
INDEX(Tabell242;;XMATCH("D" & H$4,Tabell242[#Headers],0))<>"";
"No one")
shall work