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)...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top