I have a Google Spreadsheets prepared: example sheet and in column
I, I want to list every player in column
B if the value in column
What formula do I need to use in column I?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
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
=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.
An alternative to the answer already given, is the following formula in
If there are more then one entries to expect, add the following formula:
Sorting the range can be done with the sort function:
1 in the sort represents the first and only column. The
TRUE will sort the range ascendingly and
FALSE will sort it descendingly.