title: Excel - Index Match where max value (return multiple results and remove duplicates)
body: <p>I have an index match formula like so:</p>
  
  <pre><code>=INDEX('Opp Data'!H:H, MATCH(MAX('Opp Data'!I:I), 'Opp Data'!I:I, 0))
  </code></pre>
  
  <p>This looks up my data on Opp Data sheet:</p>
  
  <pre><code>Column H          Column I
  Client A          £100
  Client B          £50
  Client C          £0
  </code></pre>
  
  <p>the formula then returns my the client name with the corresponding largest spend:</p>
  
  <p>i.e. <code>Client A</code></p>
  
  <p>Next, i need to be able to produce multiple results, so i need to repeat this formula down several rows on my spreadsheet and each time return the next largest value (without showing duplicates). For example:</p>
  
  <pre><code>Client A
  Client B
  etc.
  </code></pre>
  
  <p>Please can someone show me how to do this? Thanks in advance </p>