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

    <p>Hi,</p><p>I have a unbound spread that displays multiple rows of numbers.  </p><p>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.</p><p>How can I do this? <br></p>Thanks<br>
  • Replied 8 September 2017, 1:53 pm EST

    <P>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.</P>
Need extra support?

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

Learn More

Forum Channels