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.
Could the LET function be used here?
Never used it before..
Attached is a samle file.
- Geir