Take the 2-minute tour ×
Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems.. It's 100% free, no registration required.

In LibreOffice calc I have a column with thousands of values. Is there an easy way to list the number of UNIQUE values?

e.g. a column which had

red
red
red
green
green
blue
blue
blue

would return 3 because there are three unique entries.

Thanks

share|improve this question
    
I flagged it, because it belongs on Superuser, imho. There is no buildin function, afaik, to do what you want. Maybe an extension somewhere? –  user unknown Oct 14 '11 at 10:50
    
@userunknown I think it's fine; one of our on-topic bullets is "Applications packaged in *nix distributions" –  Michael Mrozek Oct 14 '11 at 13:44

1 Answer 1

If it is a one-off, the easiest way to do this is to use a datapilot table and use that column as the row dimension. That will aggregate the list of values. Then you can just use functions like count if you want the number, or simple copy and paste if you want the unique list.

Using the datapilot table it would also be easy to just add a data element of count which would count the number of unique entries of each element.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.