+ Reply to Thread
Results 1 to 2 of 2

Creating relationship between 2 sheets of data

  1. #1
    Registered User
    Join Date
    10-02-2008
    Location
    Australia
    Posts
    5

    Creating relationship between 2 sheets of data

    Hi,

    I have 2 sheets of data, each with a unique key. Lets call them "Problems" and "Fixes"

    Now each Problem is unique, however Fixes can apply to multiple problems

    Eg,
    Problems are:
    10,11,12,13

    Fixes are:
    20, 21, 22, 23

    Problem to fix relationship:
    10 - 21, 22
    11 - 20, 21
    12 - 20 ,21, 23
    13 - 21

    If that makes sense.

    So what i want to do is a data dump pulling out all the problems that apply to a certain scenario, and automatically list the fixes next to the problems.

    I'm having trouble working out how best to structure this. Any ideas?

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Creating relationship between 2 sheets of data

    This is a perfect case for a pivot table.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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