I am compiling a chart of information for a game but am way over my head trying to figure out how to arrive at my goal.
Info:
There are 111 names.
There are 55 different attributes.
Each name will have four unique attributes (no name will have the same attribute twice).
Each name already has assigned attributes, and they will not change.
Column A is the name; Columns B, C, D and E are the attributes.
Goal:
Display all possible groups of 2, 3 or 4 names when the names share at least one of the same attribute.
Example:
Attribute 1 Attribute 2 Attribute 3 Attribute 4
Name 1 RP FS RM RH
Name 2 DM WB RH FP
Name 3 RS WB FM RM
In the example above, Name 1 shares one attribute with Name 2 (RH) and one attribute with Name 3 (RM). Further, Name 2 shares a separate attribute (WB) with Name 3. This would result in a group of three that lists Name 1, Name 2 and Name 3.
I regularly use Excel for charts and lists, but the extent of my use of functions caps out at nested IF statements. There are seemingly thousands of possibilities (given the data set), so I expect the final list of groups to be several thousand long, but I don’t care how long the formula(s) or outcome(s) will be if the result is accurate and complete.
Thanks in advance for any help or guidance!
Bookmarks