• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. T

    find nearest value in a list with coma's

    That works. brilliant. thankyou
  2. T

    find nearest value in a list with coma's

    Hi thanks for the all the input to help me rectify this issue. with so many formulas, im confused as to which one should resolve my issue. i have copied and pasted all the excel formulas above and still get #N/A. i don't know VB. im just a regular excel user. also not sure what you mean by "in...
  3. T

    find nearest value in a list with coma's

    Hi i am trying to return a value in excel 2010. i have a list of numbers in one cell separated by coma's (3,5,7,9,11,13) i want to find the exact value or the next highest if the exact value isn't there. for example a search for 4 would return 5 and a search for 7 would return 7 many...
Back
Top