mercredi 8 juin 2016

INDEX(SMALL(IF equation only returning one criteria instead of multiple

I'm using the following formula to return the end time for multiple classes. However, it is only returning multiple results for certain class pairs but not all. I can't seem to find the issue in the equation.

{=IF(ISERROR(INDEX($I:$I,SMALL(IF(($H:$H=$B$2)*($J:$J=$C$2),ROW(H:H)),ROW(3:3)))),"",INDEX($I:$I,SMALL(IF(($H:$H=$B$2)*($J:$J=$C$2),ROW(H:H)),ROW(3:3))))}

Thanks!

Aucun commentaire:

Enregistrer un commentaire