Hi ,


My data is set-up in format.

A B D E
Hours DeptName Criteria Results

B
8.34
7.64 A
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 is the hours.
Column B are the Dept Name

Cell D2 Has the Dept.name
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?