Filtering a column to exclude any repeated entries.

B

bay

Hi,

I am working on a column that has the same entries 2 or more times. Is there
a way (copy-paste or other) to get only unique entries from this
column (that is to exclude repeated entries)?

Any help apprieciated,

Thank you.
 
G

Guest

If you go to Data/Filters/Advanced Filters there is a box
at the bottom left that you can tick to return unique
entries only.
 
A

Aladin Akyurek

If the data has a distinct header/label...

Activate the destination sheet.
Fire up Data|Filter|Advanced Filter.
Check the option "Copy to another location".
Click in the box for List range and select the source data.
Leave the box for Criteria range empty.
Click in the box for Copy to and select a cell on destination.
Check the "Unique records only" option.
Click OK.

Another option is to invoke a fast-working formula system, but, I guess,
Advanced Filter would suffice.
 
Top