Do you have a better Excel formula that doesn't break my computer? Index & Match & CountIF

E2=IFERROR(INDEX($A$2:$A$100,AGGREGATE(15,6,ROW($A$2:$A$100)-ROW($A$2)+1/($B$2:$B$100=$D2),COUNTIF($D$2:D2,D2))),"")


copy down

That amazing!

But how can I add the two other criterias?

Formula:

Please Login or Register  to view this content.

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

Try

E2=IFERROR(INDEX($A$2:$A$100,AGGREGATE(15,6,ROW($A$2:$A$100)-ROW($A$2)+1/($B$2:$B$100=$D2)/($C$2:$C$100<>"Bachelors")/(LEFT($C$2:$C$100,4)<>"Bach"),COUNTIF($D$2:D2,D2))),"")

Copy down

You are welcome