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

    How do i skip an index that returns false

    =IFERROR(INDEX(ConcessionTracker!$H$3:$H$23, SMALL(IF(ConcessionTracker!$M$3:$M$23 = "CONTESTED", ROW(ConcessionTracker!$M$3:$M$23) - MIN(ROW(ConcessionTracker!$M$3:$M$23)) + 1), ROWS($A$1:$A1))), "") ok so i changed the table name to ConcessionTracker and changed the points from B5-B25 to...
  2. C

    How do i skip an index that returns false

    Thanks guys, that's exactly what i was wanting! :DD
  3. C

    How do i skip an index that returns false

    this has changed to a completely different question now. my original question was based of what i had which was wrong. now i am basically asking how you would do it
  4. C

    How do i skip an index that returns false

    i made a rough copy of the tables i have, i want the Q numbers and the reasons of only the contested concessions moved from table1 to table2
  5. C

    How do i skip an index that returns false

    using filter? would that still work when the array you are getting it from is 20 down and the place you are putting it is only 10 down? i ask this as when i try it i get an error saying it will override data in a cell, also if i give it enough room it then removes the entire row, there is...
  6. C

    How do i skip an index that returns false

    Ignoring the if statement, what function would i have to use to in order for an INDEX to not display the rows that don't contain the specific information? also thanks for the quick reply
  7. C

    How do i skip an index that returns false

    when i used what i had it returned Q27058107713 FALSE FALSE FALSE FALSE Q27487107112 FALSE FALSE FALSE FALSE FALSE Q11058245613 FALSE FALSE FALSE FALSE FALSE Q27497857413 FALSE FALSE FALSE. what i wanted was for it to just return Q27058107713 Q27487107112 Q11058245613 Q27497857413 without...
  8. C

    How do i skip an index that returns false

    =INDEX(IF(ConcessionTracker!M3:M23="CONTESTED",ConcessionTracker!H3:H23),"") I have came up with this and it returns a list containing what i need but also FALSE for every one that doesn't meet the criteria. All i want is for it to return the value in the h for just the ones that have...
Back
Top