Macro to delete all Duplicate items in Col B

[flupsie]

I have code to delete all items that are duplicated, but none are being deleted


I have attached my workbook showing the duplicated items and the rows containing the items highlighted are to be deleted


The macro is

Please Login or Register  to view this content.

It would be appreciated if someone could kindly amend my code to accommodate my request

[BadlySpelledBuoy]

There's no file attached.

BSB

[flupsie]

My apologies-forgot to attach the workbook

[Fluff13]

You're putting the formula in starting at C6, it needs to start in C2, like

Please Login or Register  to view this content.

[flupsie]

Thanks for your input


I need the code amended so that all duplicates are removed for eg if KL-803133022 appears more than once all the references for KL-803133022 are to to be deleted


I have attached a workbook showing which items should be left once the duplicate items are deleted


Kindly amend my code

[Fluff13]

Have you tried the change I suggested?
As that works on the original file

[flupsie]

I have amended the macro as suggested



I have attached a workbook after running the macro to show you what items remain. The original data is on sheet "original Data"


Please check & amend

[Fluff13]

It's not working because you have changed the formula

[flupsie]

Hi Fluff13

I amended the formula from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

When running the all the items containing the same reference is to be deleted




The following items per my sample data is to be deleted


KL-803133022
KL-803133022
KL-803133060
KL-803133060


Kindly amend code accordingly

[Fluff13]

That is not a formula, this is

Please Login or Register  to view this content.

& you have changed it.

[flupsie]

Have changed it to

Please Login or Register  to view this content.

It now results in
KL-803133022
KL-803133060


The result should be

KL-803133040
KL-803133041
KL-803133061


Kindly check & amend the code

[Vraag en antwoord]

No vba needed. Use a pivottable or use Remove Duplicates or use the advanced filter.

[Fluff13]

Have changed it to

I know you've changed it. What I'm saying is change it back to what it was originally.

[flupsie]

Thanks , but I need to remove all items that are the same for eg if I have 985 in Col B and it appears more than one, for eg 3 times, then all the items containing 985 must be deleted in Col B

[flupsie]

Hi Fluff13


I changed it back to what is was originally , but still not giving me the desired result


In my example the rows containing these 4 items are to be deleted

KL-803133022
KL-803133022
KL-803133060
KL-803133060

[bakerman2]

How about this.

Please Login or Register  to view this content.

[flupsie]

Thanks for the help, Code works perfectly

[bakerman2]

Glad to help. Thanks for rep+.