Forum Discussion
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;...
- 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.
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.
Name: MyFilter
Refersto:
=FILTER(Table1[a],EVALUATE(Table1[a]&Sheet1!$C$1&Sheet1!$D$1))
Now enter =MyFilter somewhere.
- Thank you. That looks like a perfect solution. My problem is that I can not figure out what Microsoft har translated EVALUATE into in Norwegian. Could I ask you to please attach a file with =EVALUATE() only, so I can find the formula?
Best regards
- GeirHogstad_Raadgivning Attached.
- Perfect, thank you. Translated to "test" even if we do have the word "evaluere" here, Which is the same as evaluate.
_ geir
