+ Reply to Thread
Results 1 to 6 of 6

Highlighting Duplicate Cells

  1. #1
    Registered User
    Join Date
    04-17-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2003
    Posts
    43

    Highlighting Duplicate Cells

    Hello,
    In my spreadsheet column A contains thousands of cells containing names , some of which are duplicate names. In column J I have a seperate list of names, some of which are also in column A. I want to highlight a cell in column A if the name in it is the same as one of the names in a cell from column J.

    I need to be able to quickly look at a name in column J and be able to indicate how many time that name shows up in column B, if the name shows up at all.

    This task is performed on a monthly basis so it would be great to figure out a less time consuming way of doing this.

    Thank you for any help!

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Highlighting Duplicate Cells

    In K1 enter this formula and copy down the length of the list of names:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    This will count how many times each name appears in the list in column A.

    The duplicate names in column A can be identified using conditional formatting. I don't have version 2003 so can't say for sure what will work for that but you could select column A and in conditional formatting enter this formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and select the formatting of your choice. All entries in column A that are in column J should be formatted according to your choice of formatting.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    04-17-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2003
    Posts
    43

    Re: Highlighting Duplicate Cells

    Thanks newdoverman, that works!

  4. #4
    Registered User
    Join Date
    04-17-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2003
    Posts
    43

    Re: Highlighting Duplicate Cells

    Actually, the conditional formatting didn't quite work. What I want to do seems so simple, yet I can't figure it out for the life of me, which is driving me crazy.
    Thanks for your help, do you happen to have any other ideas?

  5. #5
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Highlighting Duplicate Cells

    I think the formula should be:

    =COUNTIF(J:J,A1)>1
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  6. #6
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Highlighting Duplicate Cells

    Thanks for the feedback.

+ 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. [SOLVED] Highlighting Duplicate Cells
    By paodelol in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-11-2013, 11:15 AM
  2. Replies: 2
    Last Post: 02-06-2013, 12:13 AM
  3. Finding duplicate cells and highlighting them
    By masond3 in forum Excel General
    Replies: 5
    Last Post: 08-07-2012, 08:35 AM
  4. highlighting duplicate cells
    By langdon37 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-05-2009, 05:58 AM
  5. How to Highlighting duplicate ALL cells on A:A column with red ?
    By yannipr in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-19-2008, 04:08 AM

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