Search for number closest to number entered

Posted by: sheritt on 8 September 2017, 1:53 pm EST

  • Posted 8 September 2017, 1:53 pm EST


    I have a unbound spread that displays multiple rows of numbers. 

    A user can enter a number and then I need to search a couple of columns for the number that is the closest to the number entered.

    How can I do this?

  • Replied 8 September 2017, 1:53 pm EST


    There is not a method in Spread to do this. You would need to write code to get the value from the cells in question and compare these values with each other.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels