delete duplicate

  1. 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...
  2. 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...
  3. 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 =...
  4. 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...
  5. 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)...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top