Simple question: Create new spreadsheet with values that follow one condition

Guys, I've gotten pretty rusty with Excel, so please help me out! I'll simplify it:

Say you have a list with student names on column A, their phone number on column B, and on column C information if they passed or failed (PASS/FAIL)

A1: Student B1: Phone # C1:Condition
A2: Jordan B2: 03322141 C2:Passed
A3: Cody B3: 30293095 C3:Failed

etc

I wanted to create two new different spreadsheets for those who passed and for those who failed, with the the names and phone numbers.

Which formula should I use?

Thanks a lot!

Hi
Try these in a sheet [Passed]
=IFERROR(INDEX(GlobalResults!$A$2:$C$50,IFERROR(ABS(1/AGGREGATE(15,6,-1/ROW($A$1:$A$49)*--(GlobalResults!$C$2:$C$50="Passed"),ROW(A1))),""),COLUMN(A$1)),"")

Formula:

Please Login or Register  to view this content.

where [GlobalResults!$A$2:$C$50] is your data.
Copy down an acros.
Substitute in that formula "Passed" by "Failed" to make a sheet [Failed]

I hope this helps