+ Reply to Thread
Results 1 to 3 of 3

Finding Duplicate Rows

  1. #1
    Registered User
    Join Date
    09-25-2008
    Location
    Winnetka, CA
    Posts
    83

    Finding Duplicate Rows

    I have a large table of about 50 columns. I know some of the rows are exact duplicates of each other.

    I can use the Remove Duplicates feature to delete those rows, but before I do I need to know which rows are duplicated..

    Is there a way to highlight duplicate rows? Like Conditional Formatting does, but the whole row has to match another.

    Is there a way to filter duplicate rows?

    Maybe there's an easy way to concatenate all 50 cells in the row into a new cell at the end of the row. Then I could use Conditional Formatting on that last column to find the duplicates, and filter them.

    I'm open to using VBA, but offhand I can't think of a method.

    Thanks!

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Finding Duplicate Rows

    pls attach a sample excel file
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Finding Duplicate Rows

    hope this is what you want....

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Don`t care, take care...

    Regards,
    Mangesh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Finding duplicate values in rows
    By fitkhan in forum Excel General
    Replies: 2
    Last Post: 03-24-2014, 04:53 AM
  2. Finding Duplicate Id in more than two rows in a sheet
    By mayurpatil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-14-2012, 01:40 AM
  3. Finding Duplicate Rows in 2 spreadsheets
    By eagle670 in forum Excel General
    Replies: 2
    Last Post: 06-11-2012, 01:00 PM
  4. Finding and deleting both duplicate rows
    By udfxrookie in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-17-2011, 05:41 PM
  5. Any quick way of finding duplicate rows?
    By Julesdude in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2010, 08:54 AM
  6. Matching rows in excel and finding out duplicate rows
    By ASP__DEVELOPER in forum Excel General
    Replies: 23
    Last Post: 08-17-2010, 06:20 PM
  7. Finding the sum of Duplicate Rows
    By mojocojo2000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-05-2006, 11:14 AM
  8. [SOLVED] finding duplicate rows
    By [email protected] in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-16-2006, 08:35 AM

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