http://superuser.com/questions/238656/openoffice-get-distinct-values-from-column
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.
** more options at the link