Remove Large List of Texts

[lllusion]

Hi,

First of all, what a great forum! Learnt a lot of useful info but I'm still a noob so please be kind :D

Anyway I have a large list of values such as below:

blue hats
green hats
purple hats
yellow hats
pink hats
red hats

And I'm trying to remove the rows that are duplicates to the below:

green hats
yellow hats
pink hats

Resulting in a list that only contains:

blue hats
purple hats
red hats

As I don't really understand any programming, I'd prefer a dumb solution. Thanks guys!

[Mallycat]

Investigate "advanced filters" in the help file. You can extract data to a new location and set "unique records only" to remove duplicates. No programming required

[lllusion]

Thanks for the quick reply.

I have tried that option, but in the original list:

blue hats
green hats
purple hats
yellow hats
pink hats
red hats
green hats
yellow hats
pink hats

It only seems to remove 1 duplicate row not the whole pair:

blue hats
green hats
purple hats
yellow hats
pink hats
red hats

[Mallycat]

It only seems to remove 1 duplicate row not the whole pair:

blue hats
green hats
purple hats
yellow hats
pink hats
red hats

I don't understand what you are trying to say

[lllusion]

In my original list:

blue hats
green hats
purple hats
yellow hats
pink hats
red hats
green hats
yellow hats
pink hats

You can see that the underlined are duplicates.

Using the advanced filter option I only get:

blue hats
green hats
purple hats
yellow hats
pink hats
red hats

And I'm looking to remove ALL of the duplicates (underlined rows), which should result in a final list of:

blue hats
purple hats
red hats

Hope this explains it better. Thanks.

[Mallycat]

Oh, got it. Sorry. Yes you will need vba. Sorry, I can't look at it now. Someone else may be able to help

[jraj1106]

Hi
Try this:

Book1.xlsm

Regards...

[lllusion]

Hi
Try this:

Attachment 150372

Regards...

WORKS PERFECTLY

Thank you so much jraj1106! +rep

[jraj1106]

Great to here that... Thanks for your feedback..