Skip to content

Instantly share code, notes, and snippets.

@arthurleon

arthurleon/unique-val-col-calc

Created June 25, 2015 14:44
Show Gist options
  • Star 9 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • 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
@adlingepa
Copy link

Thanks

@hozfia
Copy link

hozfia commented Nov 8, 2020

thanks simple and clear

@Drizzt321
Copy link

Drizzt321 commented Jan 26, 2021 •
edited

Doesn't work if the value in the cells are a formula, at least not for me. v6.4.6.2

EDIT: Ah, I can use Data -> Calculate -> Formulas to Values to turn them into text, and then it works

@avaleriani
Copy link

amazing, thank you

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