Count text

B

bogi_js

I got problem

column A Column B
Fruit Name Shop list
apple ABC Market
apple BBC Market
apple ABC Market
Pears 123 Shop
Pineapple 456 Shop
Orange 123 Market
Orange 234 Market

Now, I need to calculate No of unquie Fruit
& calculate no. of unquie shop

Pls hel
 
Top