Forum Discussion

Iron Contributor

May 20, 2021

Solved

Filter using dynamic operrator.

Hi, The goal here is to select the oprator from a list. So the filter function change if the selection is < > <= >= from cell reference Function =FILTER(Tabell1;INDEX(Tabell1;;XMATCH(S4;...

excel

Formulas and Functions

JKPieterse
May 20, 2021
You can do this using a range name. Suppose the > is in C1 and the value in D1, define this range name:
Name: MyFilter
Refersto:
=FILTER(Table1[a],EVALUATE(Table1[a]&Sheet1!$C$1&Sheet1!$D$1))
Now enter =MyFilter somewhere.

JKPieterse

Silver Contributor

May 20, 2021

Nope, Test is the name of the name, you can see what the formula translated to in Name Manager (Formulas tab).

Hogstad_Raadgivning

Iron Contributor

May 20, 2021

I noticed, when I looked closer.

Thank you again.

Best regards
- Geir