Deleting all duplicate items in a list

[tmitchel]

I am a tax auditor, and I am working with excel and I have two lists. One is a complete list of items, both taxable and non-taxable, the other is a list of just non-taxable. I highlighted the non-taxable sales and copied and pasted them under the main list, and I want to delete all the non-taxable items. Basically, the only duplicates in my list are non-taxable, and I need to delete ALL of them. What is the best way for me to do this?

 

[tmitchel]

Thanks MVP! I have to do this a few more times, this will definitely help! I wish I knew how to write those codes!!!

 

[HalfAce]

Most welcome.
The more times you have to do that, the more handy a little macro becomes.

I wish I knew how to write those codes!!!

You stick with us and you'll be wearing rocks the size of diamonds!

 

[Cortney]

Hello,

I'm needing to do the same thing as in remove *any and all* items that are duplicated. I've tried the VBA script and changed "a" to "C" (as my list is in the "C" column), but am not having any success.

I have 30k rows with about 75% of it are duplicate items. Any auto help w/o manually removing each double item i greatly appreciated.

Cortney