How to generate from larger list a short list that meets multiple criteria

Gentle People, I have a large amount of data, 40,000+ rows about how students do in remedial classes including from whom they took the classes. I have pulled from it a subset of student success as relates to the separate instructors. Now I would like to extract a consolidated list of those instructors for whom the student gain on criterion based pre and post course assessments is above a specific level. I have no trouble writing if statements that will look at two types of data, the course taken and the average student increase to determine which instructors meet or surpass the criterion, but I can only do that within a list that includes all the instructors. Because there are more than an hundred such instructors, it would be easier for the dean if I could provide a short list of those that meet specific criteria. I believe that it would be an array that I should use, but I have been fooling around with this for 2 days now, and am finding myself at a series of deadends!

O knowledgeable people out there, IS this possible? If so, how on earth would I do it? Any suggestions are most welcome!

sample_ew.xlsx

Absolutely. I think I have a sample attached.

sample2.docx
Thank you so very much, ChemistB, for your help! I really appreciate it!

Perhaps the formula I wrote to pull and give me the indicators in the bottom of the sample I sent you, AG33, would help. The Green 008 in that cell tells me that the course was 008 and the average gain was => 30 points on the pre-post test we give. The formula for that is
IF(AND(EP41651>=30,TRIM(EP1)="008"),"008",IF(AND(EP41651<=20,TRIM(EP1)="008"),"NO",""))
I turned it green with a conditional formatting.

What I want is to go across row 28, average difference in pre-post test scores, and identify those that are above the cut score I set AND
which also are the correct course, as indicated in row 1, as either 008, 009, or W (writing)
For those that match both criteria, I want to print the instructor's name, in rows 24 and 24, in a list, a short list, not one with 100+ rows or columns.
I am perfectly happy to have this list whereever, on a new worksheet, a new place on this worksheet, but I do want the list to be short. If it is not short, I do not see that I am gaining anything beyond what I am doing already since I am already getting that in rows 30-34, which look like the attachment, sample2, I have attached to this reply.

I get the feeling that what I would like to do is not possible, despite the fact that it would be convenient!