+ Reply to Thread
Results 1 to 3 of 3

Identifying duplicate rows (not just records)

  1. #1
    Registered User
    Join Date
    10-12-2007
    Posts
    12

    Identifying duplicate rows (not just records)

    Hi, I have a workbook with 8 different fields as column headers and wish to find any instances where all 8 of these fields are identical.

    i.e. I know there are several rows (out of several hundred) in which every column is identical and wish to distinguish these from the remaining data.

    Is there a way to identify only these duplicates?

    I don't know how well I've explained this......a simple example would be :

    Postcode - Cond
    N1 8DN - good
    N1 8DB - good
    N1 8DN - good
    N1 8DN - bad

    And i'd want it to show that rows 1 and 3 were duplicates

    Thanks

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    In column I, you could put =A1&B1&C1&D1&E1&F1&G1&H1 and drag down. Starting with J2, =IF(COUNTIF(I$1:I1,I2),"Duplicate","Unique")
    Edit: Had wrong order of arguments in Countif. This has been corrected.

  3. #3
    Registered User
    Join Date
    10-12-2007
    Posts
    12
    thanks for the quick and helpful response

    problem resolved

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1