Libre Calc and removing duplicates – create distinct values

http://superuser.com/questions/238656/openoffice-get-distinct-values-from-column

found a more simple way to do that:

  1. Select the whole column

  2. Data > Filter > Standard Filter

  3. 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