How do I remove duplications.

[Ray]

Hi,

Which function do I use to remove duplications?

Example: in Column A I have a list that is 2,000 entries
long and there are entries that contain the same user name.

 

[Aladin Akyurek]

Either run Advanced Filter with Unique records only checked or apply an
efficient formula sytem.

 

[Arvi Laanemets]

Hi

The best is to avoid unwanted duplicates at all. You can use data validation
for this.

When you have the mess already, add into some free column on row 2 (row1 is
header) the formula:
=SUMIF(A$2:A2,A2)
and copy down.

Now set autofilter on, and set filter for created column to custom: Is
greater than 1
Delete filtered entries.

Arvi Laanemets