counting of data in excel

This is my data

 

 

1

 

apple

 

mango

 

 

2

 

peach

 

coconut

 

grapes

 

3

peach

apple

 

4

peach

mango

apple

5

grapes


 

 

i want a output as below

 

apple

3

peach

3

mango

2

coconut

1

grapes

2

 

is there any formula to do this in excel?

thanks in advance.

By: vaibhav

Leave a Reply

Your email address will not be published. Required fields are marked *