Results 1 to 2 of 2

Identifying duplicate data using multiple columns

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2007
    Posts
    3

    Identifying duplicate data using multiple columns

    I need to identify, and custom format rows that have duplicate data based on data in 5 columns. My goal is for the formatting formula to:

    Highlight the rows where data in columns A, B, C, D, and E are all identical to any other rows on the sheet.

    My initial run with the COUNTIFS ($A$2:$A$XXX,$A2,...,$E$2:$E$XXX,$E2)>1 has not worked consistently. It still locates and highlights cells that only have 2 out of the 5 columns matching, and for some reason, it will randomly highlight a unique row, where nothing matches anything else on the sheet.

    I have a sheet like this come to my desk every day, and visually finding the duplicates can be tedious.

    Here's today's data set for me to sort.
    Attached Files Attached Files

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