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