generating a list of unique values in a range of data

rod.c.johnson

Sorry folks but it has been a long time since I worked with spreadsheets.

I have a range of data (numbers, dates and text) and I would like to generate a list of the unique number values in the range. I am not sure what the best way to do this is.

I had thought to sort the data by the number and use the if function to compare a number with the next number in the column, but this gives me many blank cells between each unique number. I would like something that doesn't require user intervention to generate the list, so as my data range grows, the list of unique values will grow.

There must be a simpler way but I can't think of it.

Any suggestions would be appreciated

Rod
_________________
Rod C. Johnson
------------------------------------------
Registered Linux User #249090

Villeroy · Posted: Wed Feb 24, 2010 1:09 pm Post subject:

Select the column in question and apply menu:Data>Filter>Standard copying non-empty values to a target cell with no duplicates.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

rod.c.johnson · Posted: Thu Feb 25, 2010 2:35 am Post subject:

Thanks I can work with this. I wanted to have it constantly updated but I think I can figure it out now.
_________________
Rod C. Johnson
------------------------------------------
Registered Linux User #249090

Villeroy · Posted: Thu Feb 25, 2010 4:14 am Post subject:

Define the source range as database range (Data>Define...)
Perform the operation once.
Keep your list properly. Insert cells for new records. This will update all references automatically (formulas, charts and more).

menu:Data>Refresh will refresh the target range.

In a database (even a database from a sheet) it could be as easy as:
SELECT DISTINCT "Column X" FROM "TableName"
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

Robert Tucker · Posted: Thu Feb 25, 2010 5:28 am Post subject:

Note:

Google Docs has a "Unique" function.

http://docs.google.com/support/bin/answer.py?hl=en&answer=92022

[See http://www.oooforum.org/forum/viewtopic.phtml?t=93611]
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot)