If there a simple way to count the number of different values in a range?

If I have a column with a thousand rows and I have different values in
the rows (some of which are repeated)...

Bacon
Eggs
Toast
Marmalade
Toast
Toast
Bacon


The answer I want here is 4. (the total of different entries)

I guess there must be a function for this, but I can's seem to find it.

Any help would be appreciated.



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Reply via email to