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

    Getting the 2nd and 3rd occurence

    It worked!!!! Thanks so much!
  2. J

    Getting the 2nd and 3rd occurence

    Thanks, I'm going to try it shortly.
  3. J

    Getting the 2nd and 3rd occurence

    Yes, I did enter it as an array and it's just returning "true". Can you nest the formula into my original formula? IF(ISERROR(MATCH(ROUND($E$3,10),’2013-TaskList’!$J$4:$J$5004,0)),”",INDEX(’2013-TaskList’!$K$4:$K$5004,MATCH(ROUND($E$3,10),’2013-TaskList’!$J$4:$J$5004,0))) I'm on a deadline...
  4. J

    Getting the 2nd and 3rd occurence

    Here is the actual formula and it errors out: =ISERROR(INDEX(’2013-TaskList’!$K$4:$K$5004,SMALL(IF(’2013-TaskList’!$J$4:$J$5004=$E$3,ROW(’2013-TaskList’!$J$4:$J$5004)-MIN(ROW(’2013-TaskList’!$J$4:$J$5004))+1),ROW(A1))))
  5. J

    Getting the 2nd and 3rd occurence

    I'm trying it but it's returning a True as the return value. I don't necessarily need the "round" so I excluded that but I do need the iserror so that the cell is blank if there is nothing to return. There are 2 ranges I'm working from: This is my match range: ’2013-TaskList’!$J$4:$J$5004...
  6. J

    Getting the 2nd and 3rd occurence

    I have a problem. I’m trying to populate a field based on an occurence of a value in a range and it works fine. Shown below: =IF(ISERROR(MATCH(ROUND($E$3,10),’2013-TaskList’!$J$4:$J$5004,0)),”",INDEX(’2013-TaskList’!$K$4:$K$5004,MATCH(ROUND($E$3,10),’2013-TaskList’!$J$4:$J$5004,0))) But I...
Back
Top