title: Google Sheets - how can I return participants scores by team, sorted by score?
body: <p>I have a sheet with participant scores, and each participant is in a team. In a second sheet, I have the following formula to create a subset of participant scores per team in each row.</p>
  <p>Here's a link to a <a href="https://docs.google.com/spreadsheets/d/1ExnFdF65kqqD8IkRxKL3Vboo-H081Q-XwqvxXFFM8b8/edit?usp=sharing" rel="nofollow noreferrer">sheet with sample data showing my formula</a>:</p>
  <p>How can I get the results sorted in decreasing numerical order?</p>
  <p>I've tried using the SORT() function (column C in the second sheet), but understandably, it interprets the results as text, so a score of 10 is ranked lowest.</p>