Duplicate Records

[BUCDIA]

I am trying to remove ALL duplicate records including the initial record. Using the "unique records only" leaves a version of the record. ie:

Red
Red
Yellow
Pink
Green
Green
Blue

with the "unique records only" function will leave you with

Red
Yellow
Pink
Green
Blue

I need something that removes all instances of the duplicate so I would be left with just:

Blue
Yellow
Pink

Is this possible?

 

[Robert Mika]

Hi Bucdia,
Welcome to forum,

If youe data are in column A you can try in next column use
=COUNTIF($A$1:$A$7,A1)
and then filter this column by "1".

 

[Blade Hunter]

Data / Advanced Filter

Select the range

Select copy to and choose a blank column

Tick Unique records only

Click OK.