Help Neeeded : Formula to count the different words in an array

[Elangovan89]

Hi All,

I need a formula to count the total number words occurred in an array. It has to separate the "," and count.

Here is a scenario:

1.Apple
2.Banana
3.Orange
4.Mango
5.Banana
6.Mango
7.Orange
8.Apple, Banana
9.Banana, Mango
10.Mango, Apple
11.Banana

Thanks in advance...

Elango

[XOR LX]

Duplicate post.