=IF(ISERROR(INDEX(Units!$C:$C, SMALL(IF(COUNTIF($E$1, Units!A:A)*COUNTIF($E$4, Units!B:B),ROW(Units!$C:$C)-MIN(ROW(Units!$C:$C))+1), ROW(A1)), COLUMN(A1))),0,(INDEX(Units!$C:$C, SMALL(IF(COUNTIF($E$1, Units!A:A)*COUNTIF($E$4, Units!B:B),ROW(Units!$C:$C)-MIN(ROW(Units!$C:$C))+1), ROW(A1)), COLUMN(A1))))
I have the above array formula where E1 and E4 are values in drop down boxes.
I have the formula in about 60 cells as the results are occasionally that high.
Most of the time it only returns 6 to 14 results.
Is there a way to stop the formula in the the rows after the last result?
I'm guessing this would cut down on calculation time.
Thanks in advance.
Bookmarks