8 Replies Latest reply on May 30, 2016 1:44 AM by Manuel Gruber

    Matching "Tier Levels" from two different sources

    Manuel Gruber

      Hey Guys,

       

      I´m struggling to figure out how to deal with this problem.

      Table.JPG

      So I´m trying to accomplish the thing I did in this simple Excel example.

      I have two Tables and im trying to get the output below. I want to split up the Tier Level(A) into all possible Tier Level (B) as they may differ from Tier Level(A).

       

      The output table shows how many times a Tier Level (A) is Tier 1 at Tier Level(B) and so on.

       

      I hope my problem is clear.

       

      I can´t post my workbook, because of confidential information.

       

      Thanks a lot!

       

      EDIT: The two tables are from 2 different data sources.