hi guys i have this table with 2 column, Column Name and Column Fruit Group i want a formula that will count a Fruit Group that has a name on Column Name, is that possible? thanks
in my example the Fruit Group that has a names are Mango, Orange, Guava, that is 3 group, i want a formula that will give me 3.
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Name | Fruit group | ||
2 | james | mango | ||
3 | Jessie | mango | ||
4 | mango | |||
5 | grapes | |||
6 | Jessica | orange | ||
7 | orange | |||
8 | orange | |||
9 | Minnie | Guava | ||
10 | gokou | Guava | ||
11 | Klilin | Guava | ||
12 | Guava | |||
13 | Banana | |||
14 | Banana | |||
Sheet1 |
in my example the Fruit Group that has a names are Mango, Orange, Guava, that is 3 group, i want a formula that will give me 3.