+ Reply to Thread
Results 1 to 4 of 4

Highlighting all duplicate rows without removing it

Hybrid View

  1. #1
    Registered User
    Join Date
    05-14-2012
    Location
    Spring Valley, NY
    MS-Off Ver
    Excel 2010
    Posts
    31

    Highlighting all duplicate rows without removing it

    Hi I have my data listed in numeric order in column B. These are part numbers or skus from my supplier.

    Example:
    B25: 10081
    B26: 10082
    B27: 10082
    B28: 10083
    B29: 10084

    As you can see the data in B26 & B27 are duplicated. I need to make a modification to one of the part#'s of 10082 to make it unique.
    What you don't see is the desacription is what's unique. B26 is size small and B27 is medium. I will manually make it 10082-S & 10082-M to make them unique.

    I have a lot of data in this column so I would like to highlight the ones that are duplicated but I do not want to remove them. I know Excel has a feature in where you can go to Data ==> Remove Duplicates. I do not want to remove these, I plan on modifying the duplicate part numbers but I want to only work on the skus that are listed more than one in this column.

    How do I isolate this data?

    Thanks - YR

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,057

    Re: Highlighting all duplicate rows without removing it

    Use Conditional Formatting.

    Select the range of cells you wish to test.

    On Excel's Home tab, choose Conditional Formatting, Highlight Cells Rules, and then Duplicate Values.

    Click OK within the Duplicate Values dialog box to identify the duplicate values.

    Duplicate values in the list will now be identified.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    05-14-2012
    Location
    Spring Valley, NY
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Highlighting all duplicate rows without removing it

    Perfect!! - Thank you

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,057

    Re: Highlighting all duplicate rows without removing it

    You're welcome.

+ 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. Removing duplicate rows
    By Nitefox in forum Excel Programming / VBA / Macros
    Replies: 50
    Last Post: 08-05-2014, 05:40 AM
  2. [SOLVED] Removing Duplicate Rows
    By scovich in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 10-15-2013, 02:00 PM
  3. [SOLVED] Alternate Highlighting Rows of Duplicate Part Numbers
    By cbritton796 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-27-2013, 12:41 PM
  4. [SOLVED] Highlighting Non-duplicate rows across two tables of data
    By Barking_Mad in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-05-2012, 08:30 AM
  5. [SOLVED] Highlighting duplicate rows on 2 sheets depending on Value of cell
    By BullseyeThor in forum Excel General
    Replies: 3
    Last Post: 11-16-2012, 12:00 PM
  6. Removing Unwanted Rows and summing the duplicate Rows
    By Cena in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2010, 07:00 AM
  7. removing duplicate rows
    By graeme86 in forum Excel General
    Replies: 1
    Last Post: 02-09-2007, 03:26 PM

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