Table Counting

[linum]

Hello. I have the following situation. I have a table with names and one of the columns looks something like this:

Column Names
-----------------
Apples
Oranges
Oranges
Oranges
Apples
Grapes
Bananas
Bananas

How can I run a msgbox that will tell me the total number of different names? In this example I know there are 4 different names, so how can I tell the msgbox to count and differentiate the names from the table and to then display the number 4 instead of displaying the number 8?

Any help is appreciated.

 

[klaus]

Attached an example.
The program first sorts the table and then counts every time when the next cell is different.

Best regards.

 

[linum]

Wow. This was beating my head all day yesterday. Thanks for the sample!