+ Reply to Thread
Results 1 to 5 of 5

Identify unique values help?

  1. #1
    Registered User
    Join Date
    08-30-2022
    Location
    Santa Fe, NM
    MS-Off Ver
    365
    Posts
    6

    Identify unique values help?

    I'm trying to apply some conditional formatting to highlight values that don't match. So if A2 matches B2 and matches C2 then do nothing, if they don'tmatch each other, highlight the non matches.

    I don't want helper columns since my data table is already huge and about to become bigger, and filtering isn't a good solution since I often have blank cells as well.

    I really appreciate the help, I haven't used excel for a while now and I'm rusty getting back in the saddle, thank you!

    Here's a sanitized sample of what I'm working on:

    sample excel.PNG

    Using Microsoft 365, thank you!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Identify unique values help?

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

    Please manually highlight the anomalies and explain the specific rationale.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,613

    Re: Identify unique values help?

    =countif($a$1:$c$1,$a1)<>3
    Ben Van Johnson

  4. #4
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Identify unique values help?

    Conditional formatting.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-30-2022
    Location
    Santa Fe, NM
    MS-Off Ver
    365
    Posts
    6

    Re: Identify unique values help?

    Thank you so much, this is amazing! I really appreciate it!

+ 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. Identify duplicate and Unique values in Excel
    By bjnockle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-10-2020, 02:40 AM
  2. Identify Unique Values from 2 colums
    By lucasc10 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2020, 02:04 PM
  3. Identify & extract unique values
    By panyagak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2017, 03:27 AM
  4. Compare and identify unique values from different workbooks
    By la_chua29 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2015, 01:44 AM
  5. Identify Unique values in Table
    By jyothijayanna in forum Excel General
    Replies: 11
    Last Post: 03-16-2013, 05:57 PM
  6. Identify unique values between 2 columns
    By penfold in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2012, 02:27 PM
  7. Identify and count unique values
    By mabond in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-26-2006, 10:00 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