How do I get a list of all distinct values from a column of values?
Basically, this question:
Excel: Get distinct values in column
but I need the answer for Open Office Calc instead of MS Excel.
I'm using Open Office 3.2
How do I get a list of all distinct values from a column of values? Basically, this question: Excel: Get distinct values in column but I need the answer for Open Office Calc instead of MS Excel. I'm using Open Office 3.2 


You can do this with the OpenOffice advanced filter (on the main menu..Data/Filter/Advanced Filter)
Not very intuitive, but once you get the hang of it, it goes pretty fast. 


I found a more simple way to do that:
That's it. You can copy and paste the filtered fields if you want contiguously numbered cells. 


You could try the procedure described in http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Removing_Duplicate_Rows to completely remove nonunique rows according to the column in question, or select rows based on the new column. 

