+ Reply to Thread
Results 1 to 3 of 3

Highlight different values based on duplicate in another column

  1. #1
    Registered User
    Join Date
    08-07-2018
    Location
    Estonia
    MS-Off Ver
    365
    Posts
    28

    Highlight different values based on duplicate in another column

    Hi,

    I would like to highlight cells that are different based on duplicate values in another cell.
    e.g.
    Nr - Name - buy - sell
    1 - Power supply - 15 - 20
    2 - Power supply - 10 - 20
    3 - Cola - 14 - 10
    4 - Cola - 14 - 10
    5 - Milk - 13 - 1
    6 - Milk - 13 - 2
    7 - Pringles - 15 - 10

    I want 15 and/or 10 to be highlighted, since "Power supply" is the same, but the "buy" is different. Same for 1 and 2 for "Milk". I have around 20 columns I would like to check.

    Please refer to the file attached - rows 7 and 8. I have manually coloured to red the values that differ. Rows 2 and 10 are also duplicates.

    Thanks,
    Attached Files Attached Files
    Last edited by giwi342; 02-14-2019 at 08:23 AM.

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,910

    Re: Highlight different values based on duplicate in another column

    Try this formula for CF:

    =COUNTIFS($D$2:$D$13,$D2,$E$2:$E$13,$E2,F$2:F$13,"<>"&F2)
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-07-2018
    Location
    Estonia
    MS-Off Ver
    365
    Posts
    28

    Re: Highlight different values based on duplicate in another column

    Wow, this really slows the table down . Guess it is because I have around 1500 entries and want to check 23 columns for for differences :D

    Thanks.

+ 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 rows and delete based on highest value from column
    By adnan5586 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2015, 02:05 AM
  2. Replies: 3
    Last Post: 11-26-2014, 07:12 AM
  3. Replies: 5
    Last Post: 05-27-2014, 07:23 AM
  4. How to highlight the Duplicate values in a column
    By BRout in forum Excel General
    Replies: 1
    Last Post: 10-26-2013, 02:44 PM
  5. Highlight duplicate rows based on column A but be case sensitive
    By theblade24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2013, 06:14 PM
  6. Replies: 0
    Last Post: 07-22-2011, 12:11 PM
  7. Replies: 23
    Last Post: 09-25-2009, 07:39 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