delete duplicate

  1. F

    Merge data and delete duplicates VBA

    Hi all, I am trying to build a tool in excel that can simulate and give an overview of packing plans, but i am having trouble getting a "timeline" to work. The sheets with the timeline are imported based on choice and will change in how many are imported. It needs to be VBA, the persons who...
  2. C

    Excel 2007: Delete Duplicate Records, Keep Duplicates Meeting Criteria

    Hi, I use excel a lot at work and want to start making my job easier. I am trying to learn how to use VBA, but need an answer on this issue sooner than later. I am trying to get data from a report, but I need to delete duplicate records to get accurate information. However, there are some...
  3. J

    VBA Multiple Critea Delete Duplicate Values

    Hello All, I just took my first VBA course and brand new to the forum. I was hoping for some help in deleting duplicate values based off of multiple criterea. Each item has a unique Sec Code. I do not care about the "Group column." My desired results will show the security codes with all of...
  4. J

    Del dublicates

    Anyone who could help me. That macro asks if I want to delete or not. If I choose "not" it leaves current cell red. How can I degree that. If I choose not to delete it should leave that cell as it was in the begin. Please help me. Sub oma() Range("A:A").Interior.ColorIndex = xlNone For i =...
  5. pedie

    Need help deleting repeated (duplicate) words in a range. Thanks!

    From range("A1:D150") if any word (It could be names like Pedie, Peter, Agie....excel etc etc) get repeated then I want it to be removed. As there are so many duplicate name being repeated. In this range there should be just 1 word, no repeatation.... Suppose in cells(1) and in cells(4) I...
  6. B

    Macro to Filter?

    I have a worksheet with 9000+ rows and 75 columns with many duplicate entries, containing many incomplete cells. Example: Joe Smith 111-11-1111 FL ________ Joe Smith 111-11-1111 __ Purchase Joe Smith ___________ FL Refinance I would like to consolidate this duplicated entry to one (1)...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top