Delete Duplicate Records

[Foxcan]

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.

[JBeaucaire]

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

[JBeaucaire]

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

[martindwilson]

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

[JBeaucaire]

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.

[martindwilson]

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

[Foxcan]

These two macros are only different in the colored line.

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

[Cjax]

Hi everyone - this looks very interesting to me and I'd love to know how to make it work. The problem is though that I'm not sure I understand how to add the macro..not even a little bit.

What do I actually write, where and.....well I'm just confused.

[JBeaucaire]

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.

[Cjax]

Hi JBeaucaire,

Thanks. I read the forum rules when i joined but I didn't think I was post jacking with my question. I'm actually not trying to do anything except understand the answer given to Foxcan's question. Apparently the answer you gave here works well but I don't understand the answer.

So, I'm not trying to apply this to any particular situation. Just trying to understand the answer given above to the situation described above. 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.

[NBVC]

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)

[JBeaucaire]

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.

[Cjax]

Awesome - Thanks very very much for your explanation and I will be sure to be more clear in the future when jumping into other folks threads. Have a good one.