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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why doesn't this work ? 2
V-lookup and Countif 2
Count unique with multiple criteria 3
Formating bolded text exclusively. 0
Nested formula...I think 1
how to count the number of times text occurs based on condition 3
Count no. of occurance in 2 dynamic columns within a data period 7
help with making a function to filter lists 2

Top