+ Reply to Thread
Results 1 to 4 of 4

Why do I think this one is going to be fun? Cross checking two columns to spit out one col

  1. #1
    Registered User
    Join Date
    03-28-2013
    Location
    Irvine, CA
    MS-Off Ver
    Professional Plus 2010
    Posts
    13

    Question Why do I think this one is going to be fun? Cross checking two columns to spit out one col

    Column A
    (several rows of phrases)


    Column B
    (several rows of words and phrases, some of them are the exact same words that are in column A)

    Column C
    goal: check column A against column b. spit out the keywords & keyword phrases so there are no duplications

    Example:

    A
    running
    run
    running shoes
    runner


    B
    running
    who cares about running
    I love running
    run

    C
    running
    run
    running shoes
    I love running
    who cares about running

    (See, column C rendered only 1x the word "run" and only one time the word "running" but kept the rest.)

    Why does this excite me? LOL. Can excel do something like this for me. Oh wait, a pivot table? No, not sure. Need help.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Why do I think this one is going to be fun? Cross checking two columns to spit out one

    Put all of the data in one column, select the column, Data > Remove Duplicates.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    03-28-2013
    Location
    Irvine, CA
    MS-Off Ver
    Professional Plus 2010
    Posts
    13

    Re: Why do I think this one is going to be fun? Cross checking two columns to spit out one

    Oh that sounds smart. I will try that!

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Why do I think this one is going to be fun? Cross checking two columns to spit out one

    Shouldn't "runner" be included in the column of results?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Replies: 3
    Last Post: 05-14-2013, 05:26 PM
  2. [SOLVED] Columns don't add up in cross-checking with Rows
    By steve@stanley in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-04-2013, 02:02 PM
  3. [SOLVED] Cross Checking and Filtering
    By Dinger045 in forum Excel General
    Replies: 4
    Last Post: 04-04-2012, 07:13 PM
  4. Rota Cross Checking
    By Amelia in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 02-20-2012, 02:58 PM
  5. Cross Checking Lists
    By mckee674 in forum Excel General
    Replies: 5
    Last Post: 02-18-2011, 11:39 AM

Tags for this Thread

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