Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: comparing columns of names

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Suburban KC
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Two columns of Company names; we'll call them column #1 and column #2. Some names are duplicated from column #1 to column #2 and vice versa. I want to compare the columns and produce a list of those company names that are in column #1 but not in column #2 and vice versa.

    HELP! and THANKS!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,312
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    G'day,

    Maybe there's a faster way, but you can use a pair of VLOOKUPs. Formula looks like this:

    =VLOOKUP(A2,$B$2:$B$100,1,0)

    -> that would give you a list from B that also exist in A.

    Adam

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-13 07:48, Talbott wrote:
    Two columns of Company names; we'll call them column #1 and column #2. Some names are duplicated from column #1 to column #2 and vice versa. I want to compare the columns and produce a list of those company names that are in column #1 but not in column #2 and vice versa.

    HELP! and THANKS!
    =MATCH(A1,B:B,0) will return #N/A if the value in cell A1 isn't in column B:B. Copy this formula down for each value in column A:A.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •