+ 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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,324

    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,324

    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. [SOLVED] 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