Results 1 to 2 of 2

Thread: Replace Duplicate Rows

  1. #1
    Join Date
    Jul 2010

    sad Replace Duplicate Rows

    I am new to macros and need some help. I have found numerous code for deleting all but the first instance of a duplicate row. However, I need something a little different. I have a table with about five columns of data. I need a macro that will search column 1 for duplicate entries and replace the first instance with the last one. Does anyone know if this is possible?

  2. #2
    Join Date
    Dec 2007

    Re: Replace Duplicate Rows

    The formula below will display the words "Duplicates" or "No Duplicates" indicating whether there are duplicates elements in the list A2:A11.

    =IF(MAX(COUNTIF(A2:A11,A2:A11))>1,"Duplicates","No Duplicates")

    For more information go here.

Similar Threads

  1. Delete duplicate rows using Macros
    By Dyumani in forum Windows Software
    Replies: 5
    Last Post: 12-10-2011, 11:30 AM
  2. How to combine data in duplicate rows in MS excel
    By Virginia in forum Windows Software
    Replies: 7
    Last Post: 10-07-2011, 11:13 AM
  3. How can I highlight duplicate rows of excel sheet with color?
    By Sarfaraj Khan in forum Windows Software
    Replies: 5
    Last Post: 08-01-2010, 10:15 AM
  4. Replies: 2
    Last Post: 09-07-2009, 08:57 AM
  5. Need script to identify duplicate rows
    By Dwij in forum Software Development
    Replies: 4
    Last Post: 30-06-2009, 05:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts