Having some trouble with a formula. I want to return the nth smallest matching row which fits two criteria. Here is my current formula:
=INDEX(HR_potential_participants_DB[Name], SMALL(IF((HR_potential_participants_DB[Training session]=$B$1)*(HR_potential_participants_DB[Met minimum 360 threshhold?]="No")=1, ROW(HR_potential_participants_DB[Training session])-ROW(HR_potential_participants_DB[[#Headers],[Training session]]), 10000), n), 1)
I know that the section of the formula dealing with the hard cell reference [Training session]=$B$1 works because when I pull out the second condition it functions correctly. The second half of the if statement doesn't work even on it's own, so I know it's the issue. Any ideas? (I know for a fact that many pieces of my table fit these two conditions).
Thanks!
Bookmarks