=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...
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
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...
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
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...
=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...