1. OCAU Merchandise now available! Check out our 20th Anniversary Mugs, Classic Logo Shirts and much more! Discussion here.
    Dismiss Notice

excel help - comparing mismatching data in columns

Discussion in 'General Software' started by ryooma, Jan 5, 2011.

  1. ryooma

    ryooma (Banned or Deleted)

    Joined:
    Jan 5, 2005
    Messages:
    1,265
    Location:
    zipcode 5163
    I have 2 columns A and B. I want to display in column C all data in B thats not in A.

    example
    A B C
    1 2 7
    2 5 8
    3 7
    4 8
    5

    I hope the example is clear. ty :)
     
    Last edited: Jan 5, 2011
  2. Rezin

    Rezin Member

    Joined:
    Oct 27, 2002
    Messages:
    9,490
    Clear as mud. :lol: :p

    Got another example, expanding on:

     
  3. knightfall88

    knightfall88 Member

    Joined:
    Feb 9, 2009
    Messages:
    721
    Location:
    Sydney
    wouldnt a simple VLOOKUP of B to A be good enough? And in your example, shouldn't "2" from B be displayed in C
     

Share This Page

Advertisement: