Get list of project that meet given criteria

[chaliseyp]

I have a list of project names with their current stage and estimated value.

I have used

Please Login or Register  to view this content.

to get the number of projects that are "Detailed" and have value >300 M.

How do I list the name of projects ( In this case I want Project 1, Project 6, Project 10 and Project 16)

Thanks in advance.

[Glenn Kennedy]

One way:
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$18)/(($B$2:$B$18="detailed")*($C$2:$C$18>300)),ROWS(I$3:I3))),"")

[chaliseyp]

Thanks Glenn.

Not sure how you come up with these solutions.

Do you have any recommendations for learning advanced excel functions ?

[Glenn Kennedy]

I was a basic Excel user... VLOOKUP, INDEX-MATCH and SUM/COUNT/AVERAGE stuff, not much more. I learned by asking Qs here and then, nervously at first, answering the Qs of others.