+ Reply to Thread
Results 1 to 5 of 5

highlight duplicated items in two columns contains digits, symbols, letters and spaces

  1. #1
    Forum Contributor
    Join Date
    05-08-2021
    Location
    ALQUDS
    MS-Off Ver
    2019
    Posts
    210

    highlight duplicated items in two columns contains digits, symbols, letters and spaces

    hi

    I have many items are repeated between two columns A,B what I want highlighted the duplicated data between tow columns

    if the items are duplicated in the same column or in another column with all the same spaces not different in spaces should highlighted by blue color and if the items the same elements but the different in spaces then should highlighted by green color the items contains letters ,digits and symbols if can do that without loop it will be a great
    I put the result in second sheet
    Attached Files Attached Files
    Last edited by Hasson; 06-15-2021 at 08:23 AM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: highlight duplicated items in two columns contains digits ,symbols ,letters and spaces

    Some are duplicated with the same spaces and also with different spaces. How do you decide in that case which ones should be blue and which ones should be green? See "khalid omar" for the example. You have shown some blue and some green, but I can't tell your algorithm.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    05-08-2021
    Location
    ALQUDS
    MS-Off Ver
    2019
    Posts
    210

    Re: highlight duplicated items in two columns contains digits, symbols, letters and spaces

    but I think to said that the cells contains the same elements and the same spaces should highlight by blue but if there are items contain the same elements but it's different in spaces then should highlight by green about Khalid Omar it's highlighted by blue because is the same elements and spaces , but highlighted by green it's different in spaces

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: highlight duplicated items in two columns contains digits, symbols, letters and spaces

    khalid omar in A12 and B12 are exactly the same (same spaces) as khalid omar in B4. Why is the one in B4 green instead of blue? They should all be blue.

  5. #5
    Forum Contributor
    Join Date
    05-08-2021
    Location
    ALQUDS
    MS-Off Ver
    2019
    Posts
    210

    Re: highlight duplicated items in two columns contains digits, symbols, letters and spaces

    if you see the same spaces should be blue , but I suspect that I see there is different in spaces
    any way if you see the same spaces should be blue and different should be green

+ 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. Replies: 5
    Last Post: 03-05-2019, 10:11 AM
  2. [SOLVED] extracting digits only from column with letters and digits
    By Jayne in forum Excel General
    Replies: 11
    Last Post: 08-20-2012, 10:38 PM
  3. Collect all used symbols/letters from a Column
    By wali in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2009, 05:50 AM
  4. [SOLVED] Counting letters and symbols
    By Zb Kornecki in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-23-2006, 02:35 PM
  5. How do I add symbols above the letters?
    By gpktm in forum Excel General
    Replies: 4
    Last Post: 12-14-2005, 11:45 AM
  6. [SOLVED] two letters upon another for math symbols
    By xlstatik in forum Excel General
    Replies: 2
    Last Post: 11-29-2005, 08:10 AM
  7. [SOLVED] Changing letters to symbols
    By Steve F in forum Excel General
    Replies: 1
    Last Post: 09-10-2005, 08:07 PM

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