+ Reply to Thread
Results 1 to 3 of 3

Identifying Duplicates

  1. #1
    Daywalker
    Guest

    Identifying Duplicates

    I'm moving into realms I have not been before.

    But I'll try and explain what I am trying to do. I have 3 columns with lists of part numbers ie :

    Column 1 Column 2 Column 3

    1 AB123 AB122 AB121
    2 AB124 AB123 AB122
    3 AB125 AB124 AB123

    (Note: These lists will be copied and pasted from different locations into 1 worksheet)

    What I would like the function to do is look at the 3 columns, and highlight all the duplicates, for example, colour the cells green ?.

    So Column 1 line 1, Column 2 line 2 and Column 3 line 3 would all get highlight green.

    Is that possible?.

    Cheers,

    Daywalker.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    Try this link

    http://www.cpearson.com/excel/duplic...tingDuplicates

    More about CF on this link

    http://www.contextures.com/xlCondFormat01.html

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Daywalker
    Guest
    VBA Noob,

    The second one is more like what I'm looking for, only one thing that its doing that I dont want it to.

    Looks like its working on the assumption that Column 1 is a complete list and highlighting full list. Is there a way of adding in to the calc that if any unique values are there as well (column 1), it does not highlight them as well (if that makes sense ?)

    Cheers,

    Daywalker

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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