+ Reply to Thread
Results 1 to 3 of 3

Compare 2 columns, output in 2 other columns

  1. #1
    Registered User
    Join Date
    10-18-2016
    Location
    Belgium
    MS-Off Ver
    MS 2013
    Posts
    2

    Compare 2 columns, output in 2 other columns

    I've been looking for a good way to compare inventories. I've got data in col A&B, which should match. But i've been looking for a way to compare both columns and get the output in Columns C&D.

    So I'd like to find a way to get the following:
    Column C = What's NOT in ColB, but IS in ColA
    Column D = What's NOT in ColA, but IS in ColB

    Does anyone have an idea what's the best&easiest way to get something like this? I'm assuming using macros, but i'm not a big expert at that .. Or does anyone have something similar or can put me in the right direction?

    Thanks !

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444

    Re: Compare 2 columns, output in 2 other columns

    Hi,

    Assuming current data is in columns A:B rows 1:9

    In C1, =IF(ISNUMBER(MATCH(A1,$B$1:$B$9,0)),"",A1)
    In D1, =IF(ISNUMBER(MATCH(B1,$A$1:$A$9,0)),"",B1)

    copy down row 9
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    10-18-2016
    Location
    Belgium
    MS-Off Ver
    MS 2013
    Posts
    2

    Re: Compare 2 columns, output in 2 other columns

    Found something similar already, but I had something in mind that just compares the entire columns and puts the output in C&D .. As the data in A&B will be mixed & never on the same line

+ 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. how to compare 2 columns & output 3rd column
    By Babylon65 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-10-2016, 12:35 PM
  2. [SOLVED] Formula to compare 2 columns & output missing #s
    By killerthun in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2015, 02:23 PM
  3. [SOLVED] Compare two columns and output a result
    By Alidamalang110 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-11-2015, 01:06 PM
  4. [SOLVED] Compare columns A and B and output data in A that is NOT in B?
    By steviec in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-17-2015, 12:17 PM
  5. Macro to compare two columns and output min/max
    By arpit_rao6 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-03-2010, 01:34 PM
  6. Replies: 3
    Last Post: 07-05-2006, 03:25 AM
  7. Compare 2 columns and output to a 3rd column
    By jamaican jewel in forum Excel General
    Replies: 1
    Last Post: 03-22-2006, 05:30 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