Forum Discussion

Hogstad_Raadgivning's avatar
Hogstad_Raadgivning
Iron Contributor
Feb 15, 2020
Solved

Excel filter function - dynamic include column

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"&Cellva...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 15, 2020

    Hogstad_Raadgivning 

    Geir, I didn't tested, but something like

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

    shall work

Resources