title: Selecting Top 10 with INDEX/MATCH
body: <p>I'm trying to produce a report that shows the top 10 users for each month and I'm a bit stuck on how to get it to work.</p>
  
  <p>How I'd like it to work is I'd select from E1 the date and for the results to populate in E4 down.</p>
  
  <p>I've tried using this formula </p>
  
  <pre><code>=INDEX($B$1:$B$15,MATCH($E$1,$A$1:$A$15&amp;LARGE($B$1:$B$15,D4)*1,2))
  </code></pre>
  
  <p>But I'm not sure what I'm doing wrong.</p>
  
  <p>Here is a basic version of my report.</p>
  
  <p><a href="https://i.stack.imgur.com/EpQxc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EpQxc.png" alt="sample"></a></p>