# OpenOffice: get distinct values from column

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

1. Ensure your column of data has a title at the top, e.g. title and that the data is contiguous (no empty cells) or select the whole column including empty cells by clicking on the column header.,
2. Create a filter criterion that would include all the data in your column, e.g. in cell D1 enter title; in cell D2 enter >" ". Use any unused cells in your spreadsheet - these are just temporary inputs which are needed to apply the filter.