How do I get a list of all distinct values from a column of values?
Basically, this question:
How do I get the distinct/unique values in a column in Excel?
but I need the answer for Open Office Calc instead of MS Excel.
I'm using Open Office 3.2
openofficeopenoffice-calc
How do I get a list of all distinct values from a column of values?
Basically, this question:
How do I get the distinct/unique values in a column in Excel?
but I need the answer for Open Office Calc instead of MS Excel.
I'm using Open Office 3.2
Best Answer
You can do this with the OpenOffice advanced filter (on the main menu..Data/Filter/Advanced Filter)
title
and that the data is contiguous (no empty cells) or select the whole column including empty cells by clicking on the column header.,title
; in cell D2 enter>" "
. Use any unused cells in your spreadsheet - these are just temporary inputs which are needed to apply the filter.Not very intuitive, but once you get the hang of it, it goes pretty fast.