Google sheet: sort value according to another column

Question

I'm a total n00b to this, so I'll try to explain the best I can.

I have a Google Spreadsheet prepared: example sheet
In column I, I want to list every player in column B if the value in column C is Beta.

What formula do I need to use in column I?

Answer 1

Not sure of the meaning of sort in the title of the question, but to get the requirement in the text of your question, in cell I2 enter

=query(A2:C16, "select B where C = 'Beta'")

You might want to change the query range to include more rows.

If you want the list sorted, enter instead:

=sort(query(A2:C16, "select B where C = 'Beta'"))

Also, it looks like that sheet is attached to a form. I recommend you do calculations (use formulas) in another sheet not associated with a form.

Answer 2

An alternative to the answer already given, is the following formula in I2:

=ARRAYFORMULA(FILTER(B2:B;C2:C="Beta"))

If there are more then one entries to expect, add the following formula:

=UNIQUE(ARRAYFORMULA(FILTER(B2:B;C2:C="Beta")))

Sorting the range can be done with the sort function:

=SORT(ARRAYFORMULA(FILTER(B2:B;C2:C="Beta")),1,TRUE)

The 1 in the sort represents the first and only column. The TRUE will sort the range ascendingly and FALSE will sort it descendingly.