Dashboard with Index of Column based off Keyword with adjacent column information

[xfaith13]

So I am trying to build a dashboard, took over a messy excel doc that has like 25 columns, along with multiple worksheets inside for differant purposes. But I would like to have a quick look on the first page showing

Installed
List of Names in column

Trying to add the xls document but no attachments are showing up

A B I
Dave Stuff Installed
Jim Stuff TBD
James Stuff Installed
Karl Stuff TBD
Dan Stuff N/A

Would like results to look like
Installed
Dave
James

[JohnTopley]

in C13

=IFERROR(INDEX($A$3:$A$8,AGGREGATE(15,6,ROW($A$3:$A$8)-2/($H$3:$H$8="installed"),ROWS($1:1))),"")

Copy down

[xfaith13]

Awesome thanks.
One last question, if i wanted to put it on a pull from a differant workbook?
Would I just add 'WKBK1'$A3:A14 (example).
That seems to have worked in ohter things I have tried.

Thanks

[JohnTopley]

Worksheet (rather than workbook!): yes .... that is O.K