+ Reply to Thread
Results 1 to 2 of 2

How to highlight duplicates in Excel except 1st instances

  1. 02-10-2020, 02:12 PM #1
    jagadeesh.rt
    jagadeesh.rt is offline
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Hyderbad
    MS-Off Ver
    Excel 2003
    Posts
    122

    How to highlight duplicates in Excel except 1st instances 

    Please Login or Register  to view this content.
    first instance.PNG
    Above code highlights all instances including 1st instances i need to highlight 2nd and subsequent duplicates
    Reply With QuoteRegister To Reply
  2. 02-10-2020, 07:07 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: How to highlight duplicates in Excel except 1st instances

    Hello jagadeesh.rt,

    Here is one way that works...

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel VBA to Highlight Duplicates across a workbook
    By cityinbetween in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-12-2014, 12:55 PM
  2. Get Excel to automatically recognize and highlight all instances of a word
    By JDoe314 in forum Excel General
    Replies: 5
    Last Post: 04-06-2014, 03:22 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. Macro To Compare Multiple Excel sheets and highlight duplicates
    By Rey123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2013, 05:07 AM
  5. [SOLVED] Help Needed- Excel macro to compare two columns in two worksheets and highlight duplicates
    By advent in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-10-2013, 05:17 PM
  6. Highlight and Tag Unique Instances
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-08-2013, 08:24 PM
  7. Instances - Duplicates
    By dforte in forum Excel General
    Replies: 2
    Last Post: 08-04-2010, 06:39 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1