Hello!
Let’s say range1is a spilled range that contains 3 values. We have another range called range2 that is fixed and contains 5 elements.
I want to compare first value=20 from range1 with all the values from range2 and get first value that is greater or equal to 20. After this, go to the second value from range1 and compare and get a result. And so on.
How can I achieve this dynamically?
(Let’s say range1 can have more or less elements). Thank you in advance for the help!
Example:
Range1 Range2
20 15
30 20
40 30
45
60
Desired outcome:
20
30
45
Let’s say range1is a spilled range that contains 3 values. We have another range called range2 that is fixed and contains 5 elements.
I want to compare first value=20 from range1 with all the values from range2 and get first value that is greater or equal to 20. After this, go to the second value from range1 and compare and get a result. And so on.
How can I achieve this dynamically?
(Let’s say range1 can have more or less elements). Thank you in advance for the help!
Example:
Range1 Range2
20 15
30 20
40 30
45
60
Desired outcome:
20
30
45