Andy Chaplin wrote:
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.
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_FREQUENCY_function
Or a data pilot with the same column as row field and data field with
function "Count".
http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
