+ Reply to Thread
Results 1 to 3 of 3

duplicate rows

  1. #1
    Registered User
    Join Date
    01-12-2012
    Location
    san diego
    MS-Off Ver
    Excel 2010
    Posts
    1

    Unhappy duplicate rows

    Hi,

    I know this is probably an easy one but I can't seem to make it work. I have 6 columns of 3 digit zip codes, some repeat in the same row.


    201 401 301 212 311 212

    311 412 311 212 212 311

    What is the easiest way to find duplicate rows? What I need is to compare row 1 to all rows for duplicates( of the exact row ie. a1-f1) then compare row 2 ,row 3 etc.
    I have tried =countifs but I can not make the formula work.....

    Can someone please help?




    Thank you

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: duplicate rows

    Hi

    One way to do this, is using Conditional Formatting, to fill with color the cells in your range that containing the same values.

    Formula for this, is: =COUNTIF($A1:$F1;A1)>1 And pull down as much as you need.

    Hope to helps you.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    6,522

    Re: duplicate rows

    try this in G1:
    Please Login or Register  to view this content.
    Confirmed with Ctrl-shift-enter.
    Rows with duplicated data (A:F) with others will be marked with "duplicated".

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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