+ Reply to Thread
Results 1 to 4 of 4

Extrapolating data from a three-variables chart

  1. #1
    Registered User
    Join Date
    10-02-2014
    Location
    Italy
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Extrapolating data from a three-variables chart

    Hi to everyone,

    I have a problem figuring this out... my db is arranged like this

    Competitors 1st choice 2nd choice 3rd choice
    John Basket Baseball Kayak
    Mary Kayak Basket
    Stephen Basket Baseball Golf

    and I need to figure out this

    Sport 1st choice 2nd choice 3rd choice
    Basket John;Stephen Mary
    Baseball John;Stephen
    Golf Stephen
    Kayak Mary John

    I have a non definite number of different "Competitors", and a definite number of different "sports" (33).
    Each competitor have up to 33 choices, but no "sport" can be entered twice by the same "competitor".

    I can get the total amount of e,g, "first choices" for each "sport", but I'm currently stuck at getting the precise "competitor group per priorità of choice per sport", any 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: Extrapolating data from a three-variables chart

    A
    B
    C
    D
    1
    Competitors
    1st choice
    2nd choice
    3rd choice
    2
    John Basket Baseball Kayak
    3
    Mary Kayak Basket
    4
    Stephen Basket Baseball Golf
    5
    6
    Sport
    1st choice
    2nd choice
    3rd choice
    7
    Basket John;Stephen Mary
    8
    Baseball John;Stephen
    9
    Golf Stephen
    10
    Kayak Mary John


    The formula in B7, which MUST be confirmed with Ctrl+Shift+Enter instead of just Enter, is

    =CatIf(B$2:B$4 = $A7, $A$2:$A$4, ";")

    Then copy down and right.

    Here's the UDF:

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    10-02-2014
    Location
    Italy
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Re: Extrapolating data from a three-variables chart

    it works perfectly! thank you *thumbs up*

  4. #4
    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: Extrapolating data from a three-variables chart

    You're welcome.

+ 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. need help in extrapolating to create a chart.
    By hydroboss in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-02-2012, 04:51 PM
  2. Extrapolating data within a table
    By MacroIdiot in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-25-2011, 12:20 PM
  3. Extrapolating spreadsheet data
    By djohnalyn in forum Excel General
    Replies: 4
    Last Post: 07-06-2011, 05:58 PM
  4. Extrapolating Data from 1 Period to Another?
    By stviking in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-07-2008, 08:49 AM
  5. [SOLVED] extrapolating data from chart
    By [email protected] in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-31-2006, 06:45 PM

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