title: Sorting to find maximum values
body: <p>Here is a sample data table:</p>
  
  <pre><code>ID Number   Test Type   Score
  001            A         81
  001            A         75
  001            A         93
  001            B         62
  001            B         87
  001            B         82
  002            A         91
  002            A         83
  002            B         94
  002            B         97
  </code></pre>
  
  <p>What I want, in excel, is a return of the maximum score of each test type for each id number so it would look like this...</p>
  
  <pre><code>ID Number   Test Type   Score
  001            A         93
  001            B         87
  002            A         91
  002            B         97
  </code></pre>
  
  <p>Is that possible?</p>