Skip to content

Instantly share code, notes, and snippets.

@zhanglongqi

zhanglongqi/unique-val-col-calc

Forked from arthurleon/unique-val-col-calc
Created September 5, 2017 15:12
Show Gist options
  • Save zhanglongqi/78915154b04f3e8b00153f98ffa7865a to your computer and use it in GitHub Desktop.
Save zhanglongqi/78915154b04f3e8b00153f98ffa7865a to your computer and use it in GitHub Desktop.
Download ZIP
Get unique values of a column in Libre Office Calc
Raw
unique-val-col-calc
Select the whole column
Data > Filter > Standard Filter
Change 'Field Name' to -none- , click on 'More options' and check on 'No duplication' box
Source: http://superuser.com/questions/238656/openoffice-get-distinct-values-from-column
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment