May 20 2021 02:56 AM
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;Tabell1[#Topptekster]))>U4;"")
Can the > be a cell refference?
Here the refference should be T3
Best Regards
- Geir
May 20 2021 05:01 AM
SolutionMay 20 2021 05:53 AM
May 20 2021 08:07 AM
Could the LET function be used here?
Never used it before..
Attached is a samle file.
- Geir
May 20 2021 08:23 AM
@Geir Hogstad Attached.
May 20 2021 08:39 AM
May 20 2021 08:43 AM
May 20 2021 09:17 AM
May 20 2021 05:01 AM
Solution