• 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. Krishnakumar

    find nearest value in a list with coma's

    Hi If your data in A2 on Sheet1, Define Nums Refers to: =EVALUATE("{" &Sheet1!$A2&"}") In B2, =IF(LOOKUP(B1,Nums)=B1,LOOKUP(B1,Nums),MIN(IF(Nums>B1,Nums))) Array formula. Kris
View older results
Back
Top