Hi ,
My data is set-up in format.
A B D
E
Hours DeptName Criteria Expected
Results
B
8.34
8.34 A
7.21
7.64
3.21
7.21
6.64
3.21
6.62
8.34 B
7.21
3.21
9.21 C
4.15
8.34
10.11

Column A has the hours.

Column B has the Dept Names

Cell D2 Has the criteria

I would like a formula that returns multiple results for Dept B in cell
E2 and filler down.

I could use this formula:

=INDEX(A$3:A$80,SMALL(IF(B$3:B$80=D$2,ROW(A$3:A$15 )-ROW(A$3)+1,""),ROWS(A$3¬:A3)))


But if you notice that in column B has gaps between them anyway we
could go around that?