In that case:
=IFERROR(INDEX('Raw Data'!A:A,AGGREGATE(15,6,ROW('Raw Data'!$A$3:$A$289)/(('Raw Data'!$D$3:$D$289>=200)*('Raw Data'!$D$3:$D$289<*('Raw Data'!$C$3:$C$289>0)=1000)*('Raw Data'!$E$3:$E$289<40)*('Raw Data'!$Q$3:$Q$289=0)),ROWS(A$2:A2))),"")
It's always easier with a small sheet (10-20 rows) and some manually calculated results!!! That's why we put the yellow banner up there....
Bookmarks