+ Reply to Thread
Results 1 to 2 of 2

Compare data between two columns

  1. #1
    Registered User
    Join Date
    06-10-2008
    Location
    Overland Park KS
    Posts
    15

    Compare data between two columns

    I have two columns with information that "should" match. Is there a formula or something that I can use to compare these two and bring back something to indicate the ones that ARE NOT matching!

    Thanks!!

    Crissy

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582
    If they are side by side matches, then, with your data starting in A2 and B2, in C2
    Please Login or Register  to view this content.
    If you expect each value in column B to be somewhere in Column A, you can use
    Please Login or Register  to view this content.
    This is not case sensitive but will not work if there are extra spaces or spelling errors.
    Drag the formula down the column as far as needed.
    Is that what you are looking for?

    ChemistB

+ 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. Comparing 2 columns of data
    By Gnit in forum Excel General
    Replies: 1
    Last Post: 06-30-2008, 03:59 AM
  2. Coverting Multiple columns of data into 3 columns
    By carricka in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2008, 07:26 AM
  3. Compare Two Columns In Two Worksheets To Copy And Paste A Third Column
    By uopint in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2007, 05:03 PM
  4. Macro to compare data between worksheets
    By masterp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2007, 04:34 AM
  5. Many Ols Regressions on Many Columns of Data
    By Carpenter9 in forum Excel General
    Replies: 0
    Last Post: 09-12-2006, 02:32 AM

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