vendredi 8 février 2019

How to combine duplicate data and get the largest values

I have a list of data example below:

> COLUMN A  | COLUMN B  |COLUMN C    
APPLE       |2          |RED  
PEAR        |3          |GREEN  
APPLE       |4          |RED  
BANANA      |5          |YELLOW  
BANANA      |5          |YELLOW  

I have a work sheet where i want to list the top 3 fruits combined and ranked from 1,2,3

Example below:  
(Fruit Name) |(Count)  
 1. Banana   |10  
 2. Apple    |6  
 3. Pear     |3  

Could you please advice on what formula i will need to use

I have tried to use the large(if(...,row(a1) formula but it isnt giving me the correct results based on the criterias.

Thank you

Aucun commentaire:

Enregistrer un commentaire