title: Excel - Modal value in list with IF function
body: <p>I want to find the most common value  in a list, matching the most common outcome by name.</p>
  
  <p>I know it revolves around an index with mode and match function, with an IF function in there. But can't get it down.</p>
  
  <p>Raw Data    </p>
  
  <pre><code>USER NAME       Items
  James Ile       Flat White 
  James Ile       Flat White 
  Michael Pane    Latte 
  Lily Wilk       Iced Drinks 
  Louise Coset    Millionaire Shortbread 
  Louise Wyli     Flat White 
  Louise Wyli     Millionaire Shortbread 
  Louise Wyli     English Breakfast 
  Louise Cosett   Cheese Toastie 
  Louise Wyli     Flat White
  Louise Cosett   Pineapple Sunset 
  James Court     Espresso 
  </code></pre>
  
  <p>Desired Result  </p>
  
  <pre><code>USER    
  James Ile        Flat white
  Michael Pane     Latte
  Lily Wilk        Iced Drinks
  Louise Cosett    Cheese Toastie
  Louise Wyli      Flat white
  James Court      Espresso
  </code></pre>