title: How to combine duplicate data and get the largest values
body: <p>I have a list of data example below:</p>
  
  <pre><code>&gt; COLUMN A  | COLUMN B  |COLUMN C    
  APPLE       |2          |RED  
  PEAR        |3          |GREEN  
  APPLE       |4          |RED  
  BANANA      |5          |YELLOW  
  BANANA      |5          |YELLOW  
  </code></pre>
  
  <p>I have a work sheet where i want to list the top 3 fruits combined and ranked from 1,2,3</p>
  
  <pre><code>Example below:  
  (Fruit Name) |(Count)  
   1. Banana   |10  
   2. Apple    |6  
   3. Pear     |3  
  </code></pre>
  
  <p>Could you please advice on what formula i will need to use</p>
  
  <p>I have tried to use the large(if(...,row(a1) formula but it isnt giving me the correct results based on the criterias.</p>
  
  <p>Thank you</p>