• 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


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

Recent content by sailepaty

  1. S

    Formula Challenge 016 - Unique Items in a Delimited String

    Posted in Daily Dose as well. =SUM(N(MATCH( TRIM(MID(SUBSTITUTE(A1&REPT("",8^5),",",REPT(" ",999)),ROW($1:$999)*999-998,999)), TRIM(MID(SUBSTITUTE(A1&REPT("",8^5),",",REPT(" ",999)),ROW($1:$999)*999-998,999)), 0)=ROW($1:$999)))-1 Regards
  2. S

    Index Match Strategy with Multiple Criteria

    Try this =LOOKUP(2,1/(Dates Range=vDate)*(Class Range=vClass)*(FX Range=vFX),Return Range) Regards