title: Extracting the top five maximum unique values
body: <p>I am running a Nerf league at a party and want my spreadsheet to show the top five contestants.</p>
  
  <p>Contestants are allowed unlimited entries and only their top score is counted. Entries are being collected on <a href="https://docs.google.com/a/cybjam.com/forms/d/1At-jeGoljzjvb9pkByahr2_hJPnzIRKsBf5mojm9-SA/viewform" rel="nofollow noreferrer">Google Sheets</a> and The Top 5 published on a <a href="https://docs.google.com/spreadsheets/d/1DxOAaxbVKATIDvtxgZIHLw6c9xobavp0kJzvVNQLWcg/pubhtml?gid=555769366&amp;single=true" rel="nofollow noreferrer">kiosk screen</a>.</p>
  
  <p>Here is some sample data:</p>
  
  <pre>- **Full Name,Score**
  - Test Test,3
  - Test2 Test2,1
  - Test3 Test3,10
  - Test4 Test4,3
  - Test5 Test5,42
  - Test5 Test5,500
  - Test6 Test6,20</pre>
  
  <p>Here is the formula I have so far (with thanks to <a href="https://stackoverflow.com/questions/18528624/extracting-the-top-5-maximum-values-in-excel">tigeravatar</a>):</p>
  
  <pre><code>=INDEX($A$2:$A$28,MATCH(1,INDEX(($B$2:$B$28=LARGE($B$2:$B$28,ROWS(I$1:I1)))*(COUNTIF(I$1:I1,$A$2:$A$28)=0),),0))
  </code></pre>
  
  <p>This formula shows <em>all</em> maximum values - if, for example, one person has 5 entries that are higher than everyone else, they will all be counted.</p>
  
  <p>The "top five" must show only the entry with the most points from five different contestants.  </p>
  
  <p>What do I need to do to show only the top entry that each contestant has provided?</p>