Count text

  • Thread starter Thread starter bogi_js
  • Start date Start date
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
 
Back
Top