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