I have data like this.
Code: Select all
key, start, end
1,1,100
1,80,140
2,200,300
4,250,300
I tried using Range lookup, withe input and reference as the same but i am not able to apply both the conditions.
The condition should be start not between start and end OR end not between start and end.
Range lookup is only able to do AND condition.
Is there a way to do that?
Thanks!