+ Reply to Thread
Results 1 to 3 of 3

How Do I Find Mismatched Data?

  1. #1
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    2021
    Posts
    205

    How Do I Find Mismatched Data?

    For a given set of Data in ColumnA, the data in columnB needs to be identical. I'd like to highlight anything that is not identical. I've attached an example sheet to better explain what my goal is.

    ColumnA represents the data sets. ColumnB represents the data that should be identical. Columns D and E are repeats of columns A and B, but it's highlighted to show the desired result when the data in columnB are not identical.

    I'd really appreciate any help you guys can give me.

    Thanks!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-16-2010
    Location
    us
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: How Do I Find Mismatched Data?

    You can do a simple conditional format and use an IF formula: =IF(A1=B1,TRUE)
    When you have a True value you can have it highlight the cell

  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: How Do I Find Mismatched Data?

    Select column B and invoke conditional formatting from the Home tab, select New Rule and select Use a formula to determine what cells to format...

    enter formula:

    =COUNTIF(A:A,A1)<>COUNTIFS(A:A,A1,B:B,B1)

    Click Format and choose from Fill tab.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ 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