+ Reply to Thread
Results 1 to 4 of 4

Highlight Duplicates not working

  1. #1
    Registered User
    Join Date
    11-15-2018
    Location
    La Crete, Alberta
    MS-Off Ver
    2016
    Posts
    14

    Highlight Duplicates not working

    I have tried everything I can think of and I can not get the highlight duplicates to work with my data.
    I'm trying to find duplicates between 2 columns of data, but only a few of the duplicates are highlighted out of about 500+ lines that should be.
    I have taken out extra spaces, used the CLEAN function to take out non printable characters. I have copied the data in column A and pasted formatting into column B, heck I even copied both columns and pasted as values in a new workbook. That was the data after I used the CLEAN function on it.

    I have attached the new workbook that I pasted my data in as values. That is sheet 1. Sheet 2 is the original untouched data.

    I just don't know what else to try. Please help if you can.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,664

    Re: Highlight Duplicates not working

    The dashes in column A are not being recognised as the same characters as those in column B. They are the source if your problem - remove them from both columns abd you will get a match.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    11-15-2018
    Location
    La Crete, Alberta
    MS-Off Ver
    2016
    Posts
    14

    Re: Highlight Duplicates not working

    You're a genius! Thank you!
    How is there such a thing as different types of dashes? My keyboard can't even produce that sort of dash.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,664

    Re: Highlight Duplicates not working

    You might find this of interest: https://jkorpela.fi/dashes.html

+ 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. Highlight duplicates in 2 columns: Keep duplicates, delete rest
    By tobyvb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2021, 06:27 AM
  2. [SOLVED] Highlight Duplicates between Sheet1 and Sheet2, ignoring duplicates already in Sheet1
    By KariSaga in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-04-2019, 05:06 AM
  3. Highlight duplicates not working in excel 2010
    By MDTService in forum Excel General
    Replies: 7
    Last Post: 11-13-2013, 03:29 PM
  4. Highlight Duplicates in Red
    By trevor2524 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2013, 08:50 PM
  5. Highlight duplicates if col A and B are the same but not col C
    By Hond70 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2011, 05:01 AM
  6. Macro to check for duplicates and highlight duplicates
    By obc1126 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2008, 09:55 PM
  7. Highlight duplicates
    By SITCFanTN in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2006, 06:25 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