+ Reply to Thread
Results 1 to 4 of 4

Indicating mismatches in 2 columns

  1. #1
    Registered User
    Join Date
    06-11-2015
    Location
    Armenia
    MS-Off Ver
    2013
    Posts
    10

    Indicating mismatches in 2 columns

    I have 2 columns, first one is the IDs of students for Q1, the second one is the IDs of students for Q2. In the Q2 new students were accepted and some students dropped, so there is a mismatch in the list of IDs. I need a function that will indicate those IDs that are present in column A but are not included in Column B and vise versa.

    Thank you!

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: Indicating mismatches in 2 columns

    Hi,

    Welcome to the Forum.

    I have highlighted the cells which are not in the other column & vice versa in RED in the attached sample file using "Conditional Formatting". See if this is what you are looking for.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-11-2015
    Location
    Armenia
    MS-Off Ver
    2013
    Posts
    10

    Re: Indicating mismatches in 2 columns

    This is exactly what I am looking for
    Can you please explain step by step how you did it?
    Thanks in advance

  4. #4
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: Indicating mismatches in 2 columns

    Keep the cursor in A2:

    Conditional Formatting -> New Rule -> Use a Formula to determine which cells to format -> enter the below formula in the formula bar -> choose the appropriate background color / Text Color -> Ok

    =COUNTIF(B:B,$A2)<1
    Attached Images Attached Images

+ 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. Match two columns of data - return mismatches third column
    By Silge in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-22-2014, 06:53 AM
  2. [SOLVED] formula to determine how many rows have different values in two columns (mismatches)
    By shardin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2014, 07:41 AM
  3. [SOLVED] How to display mismatches found between two columns?
    By MoRyn in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 03-23-2014, 04:03 PM
  4. Compare cell values in two different columns for mismatches
    By maacmaac in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-11-2012, 01:33 AM
  5. I need a little help with comparing columns and indicating the mat
    By IFIXPCS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-22-2006, 12:50 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