Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Question about search in a range of numbers.
Let's say I have the number 2.050. I would like to find the nearest number and then select the data in the second column.
Number | Data |
---|---|
1.000 | A |
1.550 | B |
1.800 | C |
1.900 | D |
2.000 | E |
2.075 | F |
3.000 | G |
Could one you explain to me how to do this?
Cheers,
Henco
Ah of course, thanks a lot for helping me out.
Cheers,
Henco
Still one question: the input number is a sum in my live app.
It is not possible to change the expression like this:
firstsortedvalue(Number, fabs(Number-sum(Number_input)))
Is there another way to do that?