analysis of name combinations

I have within each cell a group of names who are members of a club. Each cell is that's clubs combination of members.

so I'm analyzing the relationships between club members in terms of frequency.

while I know how to count the number of times a name appears as a member of a club, what I can't figure out is how to come up with frequency of 2 or 3 names appearing together across the clubs I'm analyzing.

taking this further - if there are 100 names, and I only care about the relationships between 10 of those names, I'd like to be able to see how many times in each cell there are names that appear together. does that make sense? perhaps my attached sheet with notes will help.

many thanks in advance, I have puzzled over this for some time.

the issue i'm having is i'm not seeing what I need to see - meaning - I see all the "1's" in the columns, but what is that telling me? that there's one occurrence for everything in the table? sorry if I'm not understanding this, but my vision was to try to have an output of the frequency of pairing of names from my 10 name list.but not sure what this is telling me...

so for example, if put the name "octagon" in multiple cells where "viking" exists, I was thinking the about should show me the amount of occurrences where they are in a club together. does that make sense? this is just showing me a "1" that they existed together, but not the frequency.

also it is not the same as the permutation problem you pointed to. in the permutation I was looking to see the number of permutations for a given 3 or 4 name set. In this problem, I'm looking for frequency of occurrences - sorry - just very stuck here.

this is almost there - but the issue is there should be only 1 count for any particular meeting of duos. Meaning, for meeting 15, I don't care how many times the name is in there, I just care that in meeting 15 there was a Janus and there was a [whoever else]. So the count of 6 isn't right, as it should only be 1x. What I want to do is find out across meetings (so the rows) .

It's very interesting how you set this up. I wouldn't have thought to do it that way. Are you able to tweak this so it's doing what we want it to do? are you able to set it up so I can easily change the inputs (names) that I want analyzed? also - I do not think it needs a table with the "Full name" b/c all anyone with the first name "Janus" are all the same. I care about how many times Janus appears in a club with the list of names I'm analyzing.

I"m sorry if I'm not explaining this well. it's a bit complex, but love what you have done so far. let me know if you need more clarity on the above.

this is also an interesting way of doing it. So the outputs are showing the number of times a meeting across the data set? I need to test this a little.

Is there a way to have an output sheet that shows the occurences above 2x ? that happens and what the number of occurrences are for the occurrences and pairs that are happening a lot?

I am not a heavy user of macros. Why would I need to change those items in VBA? sorry - just confused.

let me know on both of the above and I really appreciate the work on this.

I've uploaded an adjusted seat, so you can see what I'm trying to do.

I'm trying to get for example Cell B3 to tell me how many times Janus has met Cormorant in the data set. The trick part being that Janus has different last names and Cormorant may have different last names. They can meet only once per cell even if you see different versions of the name in there more than once.

so basically I'm trying to simplify and have an output that says in cell B3 "4" or "3" to tell me the total number of occurrences.

let me know if that helps, my adjusted sheet uploaded, but I clearly can't get it working right ..

You are an excel master. I do not know how you figured this out.

this is exactly what I need. I may want to evolve this more. would you mind if I worked with this a bit before I closed the thread? I'm going to test a few things with new data - more to come.

uploading an adjusted version where I changed a bunch of info - and of course affected the sheet's functioning.

I changed name of tabs, cleaned up how the data looks and added more data in column C (added two new names to the list separated by commas as a test) and more in Column E.

1. can you get this working with what I've done?
2. how can I make sure the data set expands beyond or E15 as that's where I'll be cutting nad pasting new sets of data. when I pasted in a data set with more rows, it doesn't seem to capture the additional data (trying to get this set so I can just cut and paste new data in going forward)

I've made some progress on this - how can I adjust the range of meetings that is being analyzed? (I want to paste new data in to test it but it won't pick up data beyond the row from your last sheet)

this is fantastic. Better than I hoped.

I consider this solved, BUT if you are up for it, you mentioned possibly making it trios vs. duos? it is not required for what I need, but I'd be interested to see it if you are amenable.

either way thank you again.

thank you so much. excellent and would have taken me about 3 years if ever to get there. I am going to work with this for a bit over the next week and have a great holiday!