+ Reply to Thread
Results 1 to 2 of 2

Find Multiple Occurences from Multiple Sources

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    1

    Find Multiple Occurences from Multiple Sources

    Hello all,

    This has been bothering me for a while and I thought I'd turn to the forums.

    So I have a set of data with a source and a value provide, however multiple sources can provide the same data. My idea was I want to state what value is provided by which source. For example,

    Source Value
    B 5
    B 1
    A 1
    C 3
    A 6
    C 5
    C 3
    A 3

    As you can see, several sources have a common value (A and B have 1, B and C have 5, etc). What I want to do is create additional columns that will say display the sources to the right of the value.

    So that it looks something like



    Value Source A Source B Source C
    3 A C
    5 B C
    1 A B
    1 A B
    3 A C
    6 A
    5 B C
    3 A C

    What I had intended to do is create some sort of IF or VLOOKUP function targeting specific sources as a time, for each column (target Source A sources, then Source B sources...) Hopefully this makes sense, and then display it in its own cell within it's respective column.

    Hopefully someone can help me out. Thanks!

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Find Multiple Occurences from Multiple Sources

    Please attach a sample workbook with expected result for getting quick solution.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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