title: Pull max for multiple identical ID's in Excel
body: <p>If I have a situation where:</p>
  
  <pre><code>Column A    Column B
  21202       100
  21202       400
  30021       503
  30021       922
  </code></pre>
  
  <p>And I wanted to make a column that only pulled the maximum for each identical Column A number such as:</p>
  
  <pre><code>Column A    Column B
  21202       400
  30021       922
  </code></pre>
  
  <p>Would I do so by using vlookup? </p>