Filtering a column to exclude any repeated entries.
 

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.

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.


-----Original Message-----
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.
.

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.

bay wrote:
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.