Removing any 2 identical cells on a list of 20,000 items

[Mr Bobo]

I have a monthly list (about 20,000 items give or take) I upload at work that save for about 1,000 items the list is identical. Is there a way I can filter out anything the same completely and be left with only new items on that list?

 

[yankee428]

Data|Filter|Advanced Filter and select the "Unique Records Only" checkbox.

 

[Mr Bobo]

I have tried this but it only removes 1 of the 2 items. I want to remove all data that is repeated and be left with new items only.

 

[Aladin Akyurek]

Keywords: Advanced Filter. Computed Criteria. Remove duplicate records. [ COUNTIF ]

I have tried this but it only removes 1 of the 2 items. I want to remove all data that is repeated and be left with new items only.

Book7
	A	B	C	D
1	X
2	a		FALSE
3	x		X
4	x		c
5	a		v
6	c		b
7	v
8	b
Sheet1

C1 left empty.

C2:

=COUNTIF($A$2:$A$8,A2)=1

Fire up Data|Filter|Advanced Filter.
Check Copy to another location.
Set:

List range to: $A$1:$A$8
Criteria range to: $C$1:$C$2
Copy to to: $C$3

Leave alone the Unique records only option.

Click OK.