Hi!
I have a dataset as follows:
Column A - Unique entity identifiers
Column B - Owner of the entity in A
I want a tiering done based on these two inputs. My ideal answer will add a third column that identifies the tier of every unique entity in column A.
There are 5 main entities that will start the tiering process. If those five entities are found in column B, I want that unique entity to return Tier 1a. If another unique entity has the same main entity, I want it to return Tier 1a. If that unique entity in A belongs to another one of the 4 main entities, it should return Tier 1b and so forth. The issue is that the owner in column B could go down 7 tiers deep so it is not as simple as created a lookup table.
Thanks in advance for any help!
