title: Creating a dynamic top 10 list in MS Excel 2010
body: <p>I have a simple table consisting of two columns:</p>
  
  <pre><code>CLIENT         REVENUE
  ___________________________
  
  A              5000 USD
  
  B              7500 USD
  
  C              6000 USD
  
  D              2500 USD
  
  ...            ...
  </code></pre>
  
  <p>I want to create a dynamic top 10 client list, that automatically updates itself as revenues are changed.</p>
  
  <p>I have already been able to list the top 10 revenues by using the LARGE function, but I have trouble with getting the clients' names next to the revenue numbers.</p>