Skip to content

Instantly share code, notes, and snippets.

@arthurleon

arthurleon/unique-val-col-calc

Created June 25, 2015 14:44
Show Gist options
  • Save arthurleon/fb1bc488463eca994518 to your computer and use it in GitHub Desktop.
Save arthurleon/fb1bc488463eca994518 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
@avaleriani
Copy link

amazing, thank you

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment