Delete Duplicate Records

I have a spreadsheet with a column of records (text ) from B1:B4000. I would like to delete the entire row of the duplicate record. Overall data set range is (A1:I4000). This spreadsheet may contain more than 1 duplicate record. Is there in easy fix?
Thanks.

Please clarify.

After evaluating B1:B4000, delete ALL values that are duplicated or delete only the duplicates...thus leaving at least one unique value for each?

A
A
B
B
B
C
D
D
E

Shoud the list above become....
A
B
C
D
E

...or
C
E

These two macros are only different in the colored line.

Please Login or Register  to view this content.

The first macro gives the result:
C
E
...from the original question I posed.

The second macro gives the result:
A
B
C
D
E

you could advanced auto filter on unique column b (filter in place,unique records only) then copy paste to a new sheet

Originally Posted by Foxcan

I would like to delete the entire row of the duplicate record.

I think that line makes it clear it's the original data he's looking to cull and not just make a list.

same thing surely? copy/paste all to new sheet?

Originally Posted by JBeaucaire

These two macros are only different in the colored line.

Thanks. This work PERFECT! This site is great thanks for everyones ideas!

Hi CJax,

One of the forum rules is to be sure and start your own thread instead of tacking on your own queries to someone else's.

So, start a thread of your own and include links to this one if this has content you're trying to adapt.

In your post, be sure to fully explain what your situation is, what you're trying to do, etc.

Jbeaucaire, I think it is okay in this instance to continue here for learning sake....as long as CJax doesn't start showing samples of trying to apply to his/her own work... then, I think it would require new thread with links (if necessary)

Originally Posted by Cjax

If I browse the forums just to learn techniques should I start a new thread everytime I have a question about an author's answer. I didn't think trying to understand a thread was the same as having my own situation i need help with.

Of course, you are correct. I apologize.

And one of the things i *really* need to do better is put comments into the code itself to explain what's going on.

Ok, let's start with your original question (which is what sounded like a topic change to me...)..."how to add a macro".

==========
How to use add a macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.
==========

If that's all you needed, great. If not, we can talk about the specifics of the macro itself. Here's the second macro with more "notes" added:

Please Login or Register  to view this content.