+ Reply to Thread
Results 1 to 3 of 3

Highlight duplicate values in a paragraph

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Highlight duplicate values in a paragraph

    Hi guys,

    Is it possible to have words duplicate highlighted in red from the following (say it is in cell A1):

    can't speak, cannot speak, can’t speak, would be nice, not even arrived, not even arrived

    Thank you

    Due to number of words i can;t split thtese by text to column it's too large!
    Thanks,

    R.



  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Highlight duplicate values in a paragraph

    1. And why is "speak" not highlighted?

    2. This can not be done with a formula. Is a VBA solution OK? If so, I will move your thread.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: Highlight duplicate values in a paragraph

    Hi Glenn,

    I`m looking at exact matches, hence why is speak is not highlighted..

    Yes I guess VBA it is. Please move It. Thank you!

+ 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 duplicate values
    By Liju144 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-15-2020, 03:11 AM
  2. Highlight or display duplicate rows not duplicate values
    By olga6542 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2019, 03:24 PM
  3. [SOLVED] Highlight the duplicate values
    By asifamanulla in forum Excel General
    Replies: 4
    Last Post: 10-20-2017, 12:34 PM
  4. [SOLVED] highlight duplicate values in their own row even if values aren't adjacent
    By terryhenderson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2016, 01:20 PM
  5. Highlight Duplicate Values
    By voniom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-18-2015, 08:48 AM
  6. Need help on how to highlight duplicate values
    By avadakedava in forum Excel General
    Replies: 3
    Last Post: 04-10-2012, 11:27 AM
  7. Highlight duplicate row values
    By Brian Tam in forum Excel General
    Replies: 5
    Last Post: 08-27-2010, 04:54 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