How do I get a list of all distinct values from a column of values?
Basically, this question:
How do I get the distinct/unique values in a column in Excel?
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:
How do I get the distinct/unique values in a column in Excel?
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)
title
and that the data is contiguous (no empty cells) or select the whole column including empty cells by clicking on the column header., title
; in cell D2 enter >" "
. Use any unused cells in your spreadsheet - these are just temporary inputs which are needed to apply the filter.Not very intuitive, but once you get the hang of it, it goes pretty fast.
<>""
instead of >" "
, it seemed to work better with my data
– gMale
Feb 17 '11 at 21:21
<> " "
worked well, while >" "
did not.
– sancho.s
Jul 12 '15 at 12:38
I found a more simple way to do that:
Select the whole column
Data > Filter > Standard Filter
Change 'Field Name' to -none- , click on 'More options' and check on 'No duplication' box
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 non-unique rows according to the column in question, or select rows based on the new column.