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.


      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.