+ Reply to Thread
Results 1 to 4 of 4

Matching a single cell to multiple cells

  1. #1
    Registered User
    Join Date
    08-23-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    1

    Matching a single cell to multiple cells

    I am trying to match a single cell to other cells sharing the same value. In the simplified example below, the idea is to show all pet stores that also contain the specified pet. The fist table demonstrates the starting data, and the second table illustrates the desired output. In the case of the actual dataset there are hundreds of "pets" and dozens of "stores". Thanks.

    Input:
    cat pet store 1
    dog pet store 1
    hamster pet store 1
    cat pet store 2
    dog pet store 2
    parrot pet store 2
    dog pet store 3
    hamster pet store 3

    Output:
    cat pet store 1 pet store 2
    dog pet store 1 pet store 2, pet store 3
    hamster pet store 1 pet store 3
    cat pet store 2 pet store 1
    dog pet store 2 pet store 1, pet store 3
    parrot pet store 2
    dog pet store 3 pet store 1, pet store 2
    hamster pet store 3 pet store 1

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,220

    Re: Matching a single cell to multiple cells

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

    Re: Matching a single cell to multiple cells

    A possible solution is a Pivot Table
    Attached Files Attached Files
    Marcelo Branco

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    mysore
    MS-Off Ver
    Excel 2007
    Posts
    3,428

    Re: Matching a single cell to multiple cells

    Pl see the attached file.
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 08-24-2013 at 03:04 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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