Function to "unique" a column's data

  • Thread starter Thread starter Hall
  • Start date Start date
H

Hall

I have a column with many non-unique values. (eg
A,A,A,B,B,C,C,C,C,D,E,E,E,etc)

Is there a function I can put in another cell that can list them uniquely?
(A,B,C,D,E,etc)
 
You could combine several functions together to extract that information.

If you only need the list once and the values in the column will not change,
then you can select those columns and do

Data=>Filter=>Advanced filter

The selected cells should be shown an the source data. Select copy to
another location, then click in the box and click in the location for the
output. Click the Unique checkbox in the lower left corner. Leave criteria
blank and click OK.
 
Back
Top